How to execute bunch of word documents in a folder one by one.

Hi Everyone,

I have a scenario here. The below code(saved as Macro) will take a word document from a path and searches for some texts and copy paste the searched text into the excel document (from where the code is running).

Now i would like to extend this process. My code should prompt the user to select a folder. That folder will have more number of word documents (as .doc files). Now My code should execute the word documents one by one in an order and before closing the finished document it should save the finished document in a name so that code should not execute the same document again and again. Is this is acheivable. can someone please help me..?

Please Login or Register  to view this content.

Hi..can anyone please help me on this

I solved this myself. Sharing the code incase anyone searching for this in future.

Please Login or Register  to view this content.