I am struggling with modifying macro code (attached) to help me extract text from word documents into an excel sheet
Basically: I have hundreds of word documents that contain the same data for different suppliers. I need to modify my macro that would access the word documents one at a time, search the word document for certain words in a 2 column table (e.g. "company" or "policy number") then extract what lies next to that name back into a field in excel.
Example
Public Liability
Company: XYZ trust pty ltd
Policy number: 12345
Professional Indemnity
Company: zxy group pty ltd
policy number: 54321
I really am lost.. and was hoping to get some quick pointers!!
I checked your code and it seems that your For loop which is parsing the data is not running under the normal modes of the operation. If you set it to false then it executes and transfers some data to excel which means that your earlier assumption is wrong in some case(i have not gone that level, it is difficult to understand which type of the data you want to extract without word file)
The other errors are at the object assignment at the pre processing cleanup process