Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A macro locates files on one PC but not another - why?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
A macro locates files on one PC but not another - why?
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
A macro locates files on one PC but not another - why?
Post your code...
-- HTH... Jim Thomlinson "dgild" wrote: 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
A macro locates files on one PC but not another - why?
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula locates common data in a cell and drops them in other shee | Excel Discussion (Misc queries) | |||
macro to hyperlink individual files in multiple files | Excel Programming | |||
Macro to open *.dat files and save as .txt (comma delimited text files) | Excel Programming | |||
Hyperlink Locates file regardless of it's location | Excel Discussion (Misc queries) | |||
Import multiple files macro can't find files | Excel Programming |