Len(Dir(fName)) not working

[Zzyzzyth]

I've seen dozens of examples using this line of code:
If Len(Dir(fName)) > 0 then 'file exists
but I can't get it to work. Is there a certain library reference that I need to include to make it work?

 

[Scott Huish]

You will need the .xls part.

Are you sure that the spaces are exactly the same, KSS 35 6, that the spaces between the characters are exactly the same as in your string, no spaces before or after exactly as in your filename?

 

[Zzyzzyth]

That did the trick HotPepper. Don't know if it was the 13 hour day, or just getting some sleep, but starting from scratch and using your line of code worked just fine. (with the .xls extension). Not sure when you last replied, but thanks for your help and sorry about the delay. I think you're 3 hours behind me.

Now, if I could just get Screen.MousePointer = vbHourglass to work. For some reason it won't compile. It wants me to declare vbHourglass. Not sure why, but that's probably another thread.

 

[Scott Huish]

Not sure where you're getting Screen. from, but if you look up MousePointer Property in the VBA help file and click on Applies To, you will see the objects you can do this with.