ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   macro copy (https://www.excelbanter.com/excel-discussion-misc-queries/140825-macro-copy.html)

Pammy

macro copy
 
I have a macro that when it runs, it goes to a server drive and gets a text
file, formats it into excel then sends a copy to all our precinct commanders,
and then it replaces the previous one on a server drive. The macro is
stored on the C drive. I need to put it on a new PC. I have tried to save
it on a disc and then go to the new PC and open it, I tried saving it on a
server drive and then try to open on the new PC. Either way it will not run,
it freezes. Any thoughts, I need to put it on the new PC.

Gary''s Student

macro copy
 
Make sure the Folder structure (directories and sub-directories) are the same
on the new PC as the old one or

Adjust any Folder-specific code in the macro
--
Gary''s Student - gsnu200718



All times are GMT +1. The time now is 11:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com