#1
|
|||
|
|||
Import/compile Word user forms into an Excel sheet
Hi,
I used the search function but couldn't find an answer to my issue... I created a user form using Word 2010 (developer tab). All the Content Control boxes (text, drop down list, date) have a unique tag attached to them. At the end of the user form, I included a "submit" button that sends the form as attached document to my email address. What I would like to do is to import the different user forms I will receive into a single Excel sheet, one form per row, while the column would be representing the tag values. Is it feasible (apart from copy/paste manually)? If yes, how? |
#2
|
|||
|
|||
Found my answer: http://www.vbaexpress.com/forum/show...l=1#post257696
|
#3
|
||||
|
||||
Yep, that's a great solution...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
FileSystemObject Compile Error: User-Defined Type Not Defined | gsrikanth | Excel Programming | 2 | 03-28-2022 06:32 AM |
How to transferring Word data to an Excel sheet | statue.919 | Word VBA | 16 | 06-18-2020 05:14 PM |
How to import Word Style Headings and body text into Excel | antztaylor | Excel | 5 | 11-08-2012 09:54 PM |
Excel sheet references in Word | ilkks | Word | 2 | 05-16-2011 03:23 AM |
compile error in Word | raco | Word | 0 | 09-28-2010 12:40 PM |