postino
01-08-2013, 03:40 AM
Hi,
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!!
any help much appreciated..
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!!
any help much appreciated..