Building Graphs from data we have from a Word Document

Resolved · High Priority · Version 2016

Wed 12 Jun 2019, 09:14 Delegate Katie said...

Katie has attended:
Excel Introduction course
Excel Intermediate course

Building Graphs from data we have from a Word Document

Good morning,

I currently work in HR and we complete our exit interviews on a word document with certain tick boxes for the individual to carry out.

My Manager has asked if there is a way of collating the information from the word document and putting it into an excel spreadsheet in graphs so we can look at averages of the answers of what people are agreeing or disagreeing on the same things?

I have the document to show you if that helps?

I look forward to hearing from you.

Kind regards,

Katie

Wed 12 Jun 2019, 19:50 Trainer Jens said...

RE: Building Graphs from data we have from a Word Document

Hi Katie,

Thank you for the forum question.

Yes I would like to see the word document.

To me it sound like it need to be VBA coded, but let me have a look at it, and when I get the document it will be clear, how it can be done.

Please send the Word document to:

info@stl-training.co.uk

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Thu 13 Jun 2019, 22:15 Trainer Jens said...

RE: Building Graphs from data we have from a Word Document

Hi Katie,

Thank you for the file.

As I assumed it can only be done by VBA coding and it takes a advanced level of VBA skills to do it.

If the goal is to automate a report from the questionnaires with charts and statistics, it is easier if the form is created in Excel or as a form in a database. If you have a 365 account Microsoft has created a form tool, which will collect the answers from the form and display the result in a report without any work to do. Well you need to create the form and design the report, but after the process will be totally automated.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Mon 17 Jun 2019, 10:55 Delegate Katie said...

RE: Building Graphs from data we have from a Word Document

Hi Jen,

Thank you for your reply.

If we do not have any colleagues that are able to help with the VBA Coding, is there a step by step guide that would be able to help us collate this information to do so?

I look forward to hearing from you.

Kind regards,

Katie

Mon 17 Jun 2019, 12:52 Trainer Jens said...

RE: Building Graphs from data we have from a Word Document

Hi Katie,

As I mentioned it takes advanced level of VBA knowledge to do this.

You can Google and find a lot, but it will not help you if you do not have VBA experience.

You will need a folder picker, you will need to loop through all the questionnaires in the folder, you will need to loop through all the form controls in the Word documents, you will need to transfer the answers to an Excel table, and much more.

https://stackoverflow.com/questions/3344649/how-to-loop-through-all-controls-in-a-form-including-controls-in-a-subform-ac

https://stackoverflow.com/questions/11526577/loop-through-all-word-files-in-directory

https://stackoverflow.com/questions/41011932/transfer-data-from-word-to-excel-via-vba

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Mon 24 Jun 2019: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Finding your worksheets quickly

The arrows to the left of the worksheets are used to move between one sheet at a time or first / last worksheet, but if you right click on the arrow buttons it gives you all worksheets in your workbook.

View all Excel hints and tips