Merge Word Docs from Excel's VBA

[Ronnet2]

Hi all,

Is it possible for Excel's VBA to merge Word docs into one document?

It needs to from Excel since in Excel I have a list of word documents. The order of the docs in this list determines the order in which they need to be merged. For example:

Excel's list range ("A1:A3"):
Cell A1: Important Papers
Cell A2: Resources
Cell A3: Something else

Related files:
H:\MergeDocs\Something else.docx
H:\MergeDocs\Important Papers.docx
H:\MergeDocs\Resources.docx

It would be great if Excel could look through range("A1:A3") and merge the docs in 'H:\MergeDocs' in the order that they appear in Excel. Is this even possible?

 

[Macropod]

There's nothing in the code I've provided that would cause any of the errors you say you're getting. Did you try the alternative code?

Perhaps you have a faulty Office installation. Try repairing it (via Windows Control Panel > Programs > Programs & Features > Microsoft Office (version) > Change > Repair).