Fluff's solution should not be affected by "the last one accessed"... so his solution should resolve your issue I hope.
I had considered his approach as an alternative to my attempts to make your method of selecting a file work, but before I got around to suggesting that he had taken care of that method
I guess that means we don't have to keep trying to solve my original approach, but out of curiosity, what was the error you were getting? I ask because I am on 32 bit version of excel, and don't get any errors. More than once I have seen a line go red because the 32/64 bit version doesn't support the other's version of a line of code, but that has never interfered with it executing.
I have also seen a variation of the function declaration that I don't believe will make a difference but could be tried (and yes I realize this is a moot point, it is more in case someone else ever searches this thread):
In which case you would use SetCurrentDirectory ThisWorkbook.Path (dropping the "A" from the function call)
Bookmarks