checking for files in excel 97 macros

[darronb]

Could someone please advice me on a bit of code to run in a macro that will check for the existance of 3 other excel spreadsheets before the macro trys to open them.

thanks.

 

[BlueMonkey]

Like duh, Excel 97 is so yesterday. It's not even supported by Microsoft anymore

Try

If Dir("T:\Apps Support\RELOGS\Call Analysis.xls") <> "" Then ' the file exists, returns "" (empty string) if the file doesn't exist.
MsgBox "File Exists"
Else
MsgBox "File does not exist"
End If


B.M.