Does someone have this spreadsheet open??

[LeanneGodney]

Hi there,

In Access I am wanting to create a spreadsheet and save it over an existing spreadsheet kept on the server. But I'd first like to check if someone else has this original file open! Cos I don't see the point in going through the creation of the spreadsheet and only afterwards finding that I can't continue because it's already open!

So is there a way through VBA that I can tell if an Excel Spreadsheet is open?

Thanks
Leanne

 

[Page410]

Prior to generating a new excel file try to delete the existing one with a Kill command (Kill "C:\My Data\myfile.xls"). Just trap the resulting error when someone has the file open (probably permission denied) and deal with it accordingly.