Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-10-2016, 05:17 AM
gmayor's Avatar
gmayor gmayor is offline Exporting multiple data sets from a single Word Form into Excel Windows 10 Exporting multiple data sets from a single Word Form into Excel Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,142
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default


See http://www.gmayor.com/ExtractDataFromForms.htm which does exactly that.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #2  
Old 09-10-2016, 07:43 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

Thanks, Graham.

I installed the recommended add-in and ran it on a single Word file containing a total of three data sets--one data set per page, as described above--with 14 content controls in each data set. The application extracted all the data into a single row with 42 columns, not, as I had hoped, into three separate rows of 14 columns each. In other words, the application didn't recognize that each page of the Word file contains a discrete set of content controls to be extracted as a separate row of data in the Excel sheet

Is there some way that I can get the application to recognize divisions between data sets and to export the data on each page into a separate row of the Excel sheet?

Thanks for any help you can offer!
Reply With Quote
Reply

Tags
export content data, vba macro

Thread Tools
Display Modes


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 05:02 AM.


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