vba does not find file even though it exists

[rossbritton26]

Hi,

I have some code which seemingly works fine. It takes a unique "ID" code from a list and then opens the file which begins with that "ID" code from a specified location.

This appears to work fine, except for one file. There appears to be no difference with the file name, extension, type or anything else when compared to all the other files which have worked!

The code is picking up the correct "ID", but then it just opens the first file in the folder instead of the required file.

Again, all other files have worked perfectly fine apart from this random one in the middle!!

Any ideas,

Ross.

 

[Andrew Poulsom]

Better post your code and the data that it's using. Nothing's random in the behaviour of VBA.

 

[nuked]

Yeah, code would be useful, together with the corresponding file name, taken from explorer>right-click>properties

 

[rossbritton26]

dont worry all sorted now, i was being extremely stupid!!

thanks anyway