problem with relative paths?

[bdee1]

I have an excel 2007 file (xlsm), which looks for a file in the same directory and if it exists, it opens it and does soem stuff with it. if it doesn't exist, it displays a msgBox saying that it doesn't exist.

It has been working great all week. Today i went to run it and even though the file i am referencing is right there in the same directory, it is saying that it doesn't exist.

It seems liek right before this started happening, I got a message about macros not being allowed which was weird because its been allowing them all week. not sure if thats related or not but i went in and changed the macro security to allow it.

so here is the code i am using to check for the existence of the file:

MyFileName = "Daily Flash Sheet_Glen Eddy.xlsx"
If Dir(MyFileName, 0) = MyFileName Then
do some stuff
Else
MsgBox "File does not exist"
End If

 

[VoG]

Maybe it is read only. Try

If Dir(MyFileName) = MyFileName Then

 

[bdee1]

I just checked the file properties and it doesn't seem to be read only. I also modified the code to be like you suggested and it still doesn't see the file.

 

[bdee1]

I cant figure what changed between yesterday and today that made it stop working. the file is definitely there so i don't know why the Dir function isn't seeing it.


whats weird is that if i run it on another computer it seems to work. so is there a setting in excel that would cause it to do this on my computer?

 

[bdee1]

I found that for some reason I have to enter the full path in order to get the Dir function to work. Before I just had the filename and it worked - weird that it needs the full path now.

 

[VoG]

I think that if you are not in the same folder as the file then Dir requires the full path.

 

[bdee1]

I think that if you are not in the same folder as the file then Dir requires the full path.

yea that was my thought too - but the two files are still in the same folder with each other.