Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-13-2014, 11:34 PM
mypouf mypouf is offline Import/compile Word user forms into an Excel sheet Windows 7 64bit Import/compile Word user forms into an Excel sheet Office 2010 64bit
Novice
Import/compile Word user forms into an Excel sheet
 
Join Date: Jul 2014
Posts: 2
mypouf is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 07-14-2014, 12:50 AM
mypouf mypouf is offline Import/compile Word user forms into an Excel sheet Windows 7 64bit Import/compile Word user forms into an Excel sheet Office 2010 64bit
Novice
Import/compile Word user forms into an Excel sheet
 
Join Date: Jul 2014
Posts: 2
mypouf is on a distinguished road
Default

Found my answer: http://www.vbaexpress.com/forum/show...l=1#post257696
Reply With Quote
  #3  
Old 07-18-2014, 09:34 PM
macropod's Avatar
macropod macropod is offline Import/compile Word user forms into an Excel sheet Windows 7 32bit Import/compile Word user forms into an Excel sheet Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Yep, that's a great solution...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import/compile Word user forms into an Excel sheet FileSystemObject Compile Error: User-Defined Type Not Defined gsrikanth Excel Programming 2 03-28-2022 06:32 AM
Import/compile Word user forms into an Excel sheet How to transferring Word data to an Excel sheet statue.919 Word VBA 16 06-18-2020 05:14 PM
Import/compile Word user forms into an Excel sheet 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

Other Forums: Access Forums

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


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