![]() |
|
#1
|
||||
|
||||
![]() 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 |
#2
|
|||
|
|||
![]()
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! |
![]() |
Tags |
export content data, vba macro |
Thread Tools | |
Display Modes | |
|
![]() |
||||
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 |
![]() |
dineshtgs | Word Tables | 1 | 04-07-2011 01:27 AM |
![]() |
Learner7 | Excel | 1 | 03-22-2011 02:35 PM |
![]() |
mzimmers | Excel | 3 | 08-23-2010 08:20 AM |