DanOfEarth
04-03-2011, 04:35 PM
I know the Darn file I'm checking for below is there and the directory is correct....yet it keeps triggering the second message box below ("The file DOES NOT EXIST"")
RecipeFullName = "C:\Documents and Settings\Dan\Desktop\Project - Eat Like a King\Charbroiled_Pork.xlsm"
If Dir("RecipeFullNameLong") <> "" Then
MsgBox "The file already exists! Either rename of check for duplicates"
Exit Sub
Else
MsgBox "The file DOES NOT EXIST"
Exit Sub
End If
I've even used the Function method of checking on the file...same thing. gotta be something simple. I've "checked If file Exist" millions of times in subs. Why now.
RecipeFullName = "C:\Documents and Settings\Dan\Desktop\Project - Eat Like a King\Charbroiled_Pork.xlsm"
If Dir("RecipeFullNameLong") <> "" Then
MsgBox "The file already exists! Either rename of check for duplicates"
Exit Sub
Else
MsgBox "The file DOES NOT EXIST"
Exit Sub
End If
I've even used the Function method of checking on the file...same thing. gotta be something simple. I've "checked If file Exist" millions of times in subs. Why now.