Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 55
Default Redirecting macros ...

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Redirecting macros ...

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Redirecting a formula in an "IF THEN" statement Eden397 Excel Worksheet Functions 13 November 21st 07 10:57 PM
Redirecting tishoo Excel Discussion (Misc queries) 12 December 27th 06 11:58 PM
Redirecting tishoo Setting up and Configuration of Excel 12 December 27th 06 11:58 PM
redirecting personal.xls BorisS Excel Discussion (Misc queries) 5 December 5th 06 11:24 AM
weird saving of a document with macros resulting with macros being transfered to the copy alfonso gonzales Excel Programming 0 December 12th 04 09:19 PM


All times are GMT +1. The time now is 12:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"