Closing an MS Excel file

[aziz rasul]

I have code that tells me that the file is open.

What code can I use to close an Excel file which is open by someone else?

 

[DJkarl]

There isn't any code you can use to do that...

Unless you are the admin on the server where the file resides, then you can look at closing the users open connection to the file, but that may cause corruption isssues.

 

[SpentGeezer]

DJKarl is right. What is your pos?

 

[aziz rasul]

I have an automated routine, which runs early in the morning, opens a file in code and writes stuff to it. However if someone has left it open before they went home, I can't save the file as it opens as read only. Hence the idea was to 'forcibly' close the file and do my stuff.

 

[SpentGeezer]

Do you have admin rights on the Server where the file resides?

 

[aziz rasul]

I'm afraid not.