Hi,

I don't post here often and I work primarily with Word and Word VBA, but occasionally need a bit of help with Excel. In this case, it might be a lot of help.


I have an existing process where I have a Word document form with content controls where the content control titles serve as column headings in a separate Excel file. Several Word forms are completed each day and the at the end of the day, I run a procedure in an Excel file where the the data in each completed Word form is extracted and saved as a new record in the Excel file. All works well.


I would like to expand my process where I have an Excel spreadsheet embedded within the Word document and data entered into the embedded Excel spreadsheet is also extracted.


Can anyone offer any tips or code on how this might be achieved?




Thank you.

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/