Hi,
I have created an Excel file with macros which allow me to create a (number of) Word report(s) from it, using mail merge.
It's working fine, until I zip the files and folder structure and copy it to another location. The same files then do the basic work alright, but Word stalls after some time and once it's finished the basic mailmerge stuff (all okay so far, except for the file naming) Excel throws an error: "Microsoft Office Excel is waiting for another application to complete an OLE action."
I don't understand why it behaves like this, because as far as I can tell all links between the Excel and Word files are relational, not linked to former location of the files or something.
I have attached the files in the same zip I created. If you would unpack these they would probably show the same behaviour. Anyone's help is much appreciated!
Thanks.
Bookmarks