A macro locates files on one PC but not another - why?

[dgild]

An excel macro goes out to the same directory you are running the macro file
from and retrieves information from all files that begin with 'DSS*'. It
runs perfectly on one person's PC and not on another. If the PC is restarted
the macro will then run. Once it has run the first time it won't run the 2nd
time and sends back an excel error saying it can't locate any files.

 

[Rick Rothstein \(MVP - VB\)]

How do you know what directory the macro is running from? How are you
determining what that directory is in your code?

Rick

 

[Jim Thomlinson]

Post your code...

 

[Gary''s Student]

Good point. ThisWorkbook.Path can be different from ActiveWorkbook.Path