Closing A Spreadsheet On Another Users Machine

[davidwillcocks]

Hi All,

We have a number of databases which export data to or link to data from a various excel spreadsheets. Often, we get problems whereby another user leaves a spreadsheet open on their machine and we are unable to access it or update it.

Does anyone know if its is possible to kick a user out of a spreadsheet using VB ? I can then run the code before the database tries to access the file!

Thanks In Advance

David Willcocks

 

[Niniel]

I don't think you can close other people's applications remotely - unless you are an administrator for that network.

 

[davidwillcocks]

Thats what I was afraid of.

Does anyone know if you can replicate any of the "shared worksheet" functions using Access VB - I may be able to do it this way ?

Cheers

David