1 Attachment(s)
Copy specific text from Word to Excel using VBA
Hello All,
I am trying to copy fields like Sales Order no. and Date with corresponding value from the word file (attached herewith). I am having multiple word files from where I need to search (different keywords) and copy paste it in my excel.
Also is there a possibility to copy the text from header?
Appreciate your help.
Regards,
Mayur
Copy specific text from Word to Excel using VBA
Quote:
Originally Posted by
macropod
There are multiple threads here showing how to extract data from Word documents and insert those data into Excel. What have you tried?
Thanks Paul for your response. I did look at "Import Words and Phrases from MS Word to Excel" but my issue is with searching on different text with corresponding values. e.g. here the 'Sales order' changes to "invoice number" in other word file and so on. Also wanted to know if we can fetch data from header.
With Regards,
Mayur
Copy specific text from Word to Excel using VBA
[QUOTE=macropod;402692]There are threads discussing that here, too. For a very recent example,
Thank you so much Paul. I used "Need to Pull Specific Data/Text from Word to Specific Cells in Excel" and it works fine!
Should I create an array as my search text will need to added / modified based on the word docs?