PDA

View Full Version : Transferring Revised Date from Multiple Word Documents and update in Excel



eva009988
07-14-2017, 10:46 AM
Hi everyone,

I am a newbie to Excel VBA. I need to accomplish an automation task using Excel VBA. It requires pulling a revised date from word files to excel sheet. Please see attached sample files.

The revised date needs to be extracted and put into the 'Revised Date' column in excel sheet. I will need this date to automatically update on the excel sheet when edited in the word file. I have multiple word files that I will need this automation task to occur with. I am not sure if this is possible, but please give me some insight on how I could accomplish this.

I would be incredibly grateful. Thank you!

1974819749