Redirecting macros ...

[Guest]

Hello I have a huge macro created by an experimented user I'm not familiar
with macros, but the problem is that the macro is referencing to a mapped
drive for users F:\\server\share at this time everything it's working fine
next week we have to create a new server containing the same info as old one
but the name from the server should be changed, my question is, exist a tool
from Microsoft or third party that automatically change the references in the
macro for the new server?

Thanks for your time and help,
Oscar

 

[Tom Ogilvy]

In the VBE, go to Edit => Replace