PDA

View Full Version : multiple word files tables to excel vba



bobbuilder
03-26-2014, 08:19 AM
is it possible for some help to generate vba to perform vba to strip data from multiple word documents and a hyperlink to original word file attached is a singe word file and the desired outcome of the excel file these word documents will all be of the same format and will all be within the same folder

bobbuilder
03-26-2014, 08:21 AM
attached is the second file for this

snb
03-27-2014, 05:10 AM
You can save the Wordfile as a txt file and import it in Excel.

PS. Does your keyboard lack , . ? capitals ?

p45cal
03-27-2014, 09:10 AM
Attached is your file with the update macro tinkered with. It's hard-coded left, right and centre so your other files had better be very similar.
I see column J contains a hyperlink but I'm not sure how you want that hyperlink constructed, I hope it's right.

bobbuilder
03-27-2014, 10:01 AM
Thanks so much does just what I am after you are a genuine hero p45cal

bobbuilder
03-27-2014, 12:29 PM
Thanks for your work on my request for VBA code it worked really well as time goes by I may need to make a few changes but it does what I require pretty much spot on. Being new to VBA it was a welcome result and hopefully seeing the way you did it will enable me to move forward , many thanks again .

I wanted to send you a personal mail but I haven't reached enough posts.