View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Roger Whitehead Roger Whitehead is offline
external usenet poster
 
Posts: 32
Default 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