Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In the VBE, go to Edit = Replace
-- Regards, Tom Ogilvy "Oscar" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Redirecting a formula in an "IF THEN" statement | Excel Worksheet Functions | |||
Redirecting | Excel Discussion (Misc queries) | |||
Redirecting | Setting up and Configuration of Excel | |||
redirecting personal.xls | Excel Discussion (Misc queries) | |||
weird saving of a document with macros resulting with macros being transfered to the copy | Excel Programming |