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.