Just open the template file normally, assuming it has been save as a
Template with the .xlt extension ; you will open a copy of the original.

Workbooks.Open PathToTemplate & "Yourtemlate.xlt"

NickHK

"jille" wrote in message
...
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!!!!