Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 02-02-2012, 02:18 PM
lrshort lrshort is offline Aggregate Data from Microsoft Word Survey Windows XP Aggregate Data from Microsoft Word Survey Office 2007
Aggregate Data from Microsoft Word Survey
Join Date: Feb 2012
Posts: 1
lrshort is on a distinguished road
Default Aggregate Data from Microsoft Word Survey

I currently have about 70 surveys with about 170 questions per survey created in Microsoft Word, each survey has identical questions. Most of the questions have 2-5 option/radio buttons as the possible answers. However, others have ActiveX textboxes. I need to find a way to aggregate the data from the surveys.

If the data were in excel, I would have no problem aggregating the data. However, I don't know how to get the data from Word to Excel, if that is even possible without manually typing it.

A friend of mine says that a macro might be able to help, but I do not even know where to start. I have only ever created basic macros by first recording the macros and then manipulating the VBA.

Any ideas?

I'm going to have another 70 or so surveys every week for the next five weeks (slightly different each week).
Reply With Quote

analyze, microsoft word 2007, surveys

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Aggregate Data from Microsoft Word Survey survey box?? rgchavan Word 1 11-04-2011 10:25 AM
Creating a survey JohnDough185 Word 2 03-31-2010 06:33 AM
Microsoft Outlook-a data file did not close properly etc., terrace Outlook 0 01-30-2010 10:08 PM
Microsoft Scheduler retrieve Calendar data badda Office 0 11-22-2009 06:04 AM
Microsoft Word Drop-Down Data to XML sigraves Word 0 09-28-2009 11:18 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 12:44 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd. is not affiliated with Microsoft