I need help with creating a macro that checks to see if a particular file name exists in the default directory and if it does open the file, if it doesn't exist run another macro....any help is greatly appreciated!
How about using the Dir() function? Here's an example:
fname = "parts list.xls"
If Dir("C:/" & fname & " ") <> "" Then
MsgBox "file exists"
MsgBox "file does not exist"