Hi,

I've got a Word macro that gets an Excel file as an object and finds data in
it. It's working beautifully except that if multiple users do the same task
at the same time (hitting the Excel file) we're getting a sharing violation
error/conflict. Normally the search and recovery of data is done seemlessly
but when multiple users are accessing the Excel file it sometimes appears
onscreen and sometimes freezes the macro.

I tried "sharing" the file and even making the Excel file a template but
neither possibility seems to provide a solution. Before abandoning Excel
altogether, I wanted to explore other options.

I thought the template version might work but noticed that that GetObject
doesn't create a new version of the file but rather opens the template
itself. Is there another methodology to open an Excel file from Word that
could work with a template (and create a separate document)?

Any ideas/hints would be appreciated!!!!