View Single Post
 
Old September 13th, 2007, 05:15 AM
shortland shortland is offline
Registered User
 
Join Date: Sep 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Closing A File When Someone Else Is Using It

Hi all,

I've used the following macro http://support.microsoft.com/kb/q138621/ within a conversion macro to check whether the final conversion spreadsheet is open or not by another user, so that it can be updated.

Is there a way of taking this one step further, and closing the open file that the other user has open, so that I can open it and update it?


Cheers.