Excel macro to merge word docs based on cell value

I have a number of word documents in one folder. I want to merge selected files out of them into a new word doc based on selection of the file names in an excel sheet. The macro has to read the file names i have selected and fetch the respective word docs and merge them in the order that can be controlled by me. The excel sheet may be in the same folder or in a different one. Please help. Thanks in advance.

Srinath.

Hi

try this macro

the file names are in the range FileRange in the excel sheet, and the Directory the files are in is set by FileDir

Please Login or Register  to view this content.

... you will need to have the Microsoft Word object library checked in tools > references in your VBA area for this to work

Hi

Thanks a lot for the code!

It works perfectly... Only hitch is that it stops merging if there are blanks in between the file names..Can you just tell me how to modify the code so that it ignores blank spaces in the cell range that we give?

Thanks in advance for your help!

Originally Posted by NickyC

Hi

try this macro

the file names are in the range FileRange in the excel sheet, and the Directory the files are in is set by FileDir

Please Login or Register  to view this content.