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!!!!

One of the pitfalls of the shared file is the one user at a time. If you try
saving to the users hard drive and then re-saving to the server file after
the user has modified the file, you open up the possibility of losing changes
that others might have made during the same time frame because only the last
saved file will prevail.
Until someone comes up with a way to process NRT changes to Excel without
closing the file to other users, it is one user at the time.

"jille" wrote:

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!!!!

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!!!!