Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-10-2016, 04:07 AM
Tom Saylor Tom Saylor is offline Exporting multiple data sets from a single Word Form into Excel Windows Vista Exporting multiple data sets from a single Word Form into Excel Office 2007
Novice
Exporting multiple data sets from a single Word Form into Excel
 
Join Date: Sep 2016
Posts: 6
Tom Saylor is on a distinguished road
Default Exporting multiple data sets from a single Word Form into Excel


PROBLEM: I have a multi-page MS Word file, each page of which contains a single discrete data set, with each datum entered as a content control. [In this case, each data set comprises a question and five multiple-choice answers, along with some classifications.] I want to export the data from this Word file into an Excel sheet so that each data set appears in a separate row in the spreadsheet.

Is there a macro available that will allow me to make this transfer?



I’ve found a macro created by Paul Edstein to export data from multiple Word files, each containing a single data set, but I need a macro that allows me to export data from a single Word file containing multiple data sets.
Reply With Quote
 

Tags
export content data, vba macro



Similar Threads
Thread Thread Starter Forum Replies Last Post
merging data sets in excel 2013 nwiabrad Excel 9 07-24-2014 12:07 AM
Export data from multiple attachments into a single excel document Woolstar Outlook 0 12-07-2011 09:49 AM
Exporting multiple data sets from a single Word Form into Excel Copying Multiple tables from excel into a single word document dineshtgs Word Tables 1 04-07-2011 01:27 AM
Exporting multiple data sets from a single Word Form into Excel How can I break a single group of words into three sets? Learner7 Excel 1 03-22-2011 02:35 PM
Exporting multiple data sets from a single Word Form into Excel moving data from single to multiple columns? mzimmers Excel 3 08-23-2010 08:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:53 PM.


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