Excel XP & 2003, Win XP
I'm helping an OP with some code and I have run into a problem that I have
not seen before. The code involves a FOR loop through all the files in a
sub folder to the ThisWorkbook.Path folder. The path line of code looks
like:
ThePath=ThisWorkbook.Path & "\OtherFolder"
The code works just fine on my computer and fine on his computer except when
partitions come into play.
I have just 1 partition on my hard drive. He has C, D, E, F.
All of his programs, including Excel, are on the D partition. All of his
files, including ThisWorkbook and "OtherFolder" are on the C partition.
The code will not work correctly on his computer every time. Sometimes the
code cannot find a file, other times it can. I don't see any difference in
his operation than mine except for the partitions.
Question: Does anyone know of problems with having a setup like his?
Thanks for your time. Otto