Word Mail Merge and Personal.xls problem
More info please; The VBA code is in Personal.XLS;
where is the data source?
"Dockum" wrote in message
oups.com...
Hi,
I've build a macro in Excel to perform a Mail Merge in Word with a
small Printfile.xls. The macro itself is stored in a personal.xls.
Everytime the macro performs the "OpenDataSource" function in Word, the
whole system comes to a halt and I have to wait for another
excel-instance to start (I guess from within Word) which will always
show me a messagebox to tell me the personal.xls workbook is locked.
How can I evade this? I don't need excel to open the personal.xls for
me again when opening the printfile.xls.
I'm rather stuck here and any help will be very appreciated.
Thanks in advance,
Dockum
|