Good point. ThisWorkbook.Path can be different from ActiveWorkbook.Path
--
Gary''s Student - gsnu200799
"Rick Rothstein (MVP -
VB)" wrote:
How do you know what directory the macro is running from? How are you
determining what that directory is in your code?
Rick
"dgild" wrote in message
...
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.