macros with specific drive

sas_geek · 27-Jul-2010, 08:23 PM #1

I have alot of macros on my network drive (I drive)and the Network admin is telling us we must remap the drive the R drive.
How do I get my Excel macros to change?

HiTechCoach · 27-Jul-2010, 10:24 PM #2

Quote:

Originally Posted by sas_geek

I have alot of macros on my network drive (I drive)and the Network admin is telling us we must remap the drive the R drive.
How do I get my Excel macros to change?

Make a back up first!

Maybe try a find and replace.

sas_geek · 27-Jul-2010, 11:06 PM #3

I have over 100 macros. I'm looking for an automated way

Keebellah · 29-Jul-2010, 02:11 AM #4

Still, it's bad practice to hardcode driveletters
Search and Replace works fine through a whole project but DON'T FORGET TO BACKUP FIRST

Similar Threads
Title	Thread Starter	Forum	Replies	Last Post
Solved: Help with Hard Drive	k4ourth	Windows Vista	10	28-Nov-2009 08:28 PM
something wrong with Hard Drive/Fan	ghostfire231	Hardware	6	28-Oct-2009 05:10 PM
Help Needed for Excel Macro - Copy specific cells and paste into a Summary workbook	VbaClueless	Business Applications	1	10-Sep-2008 03:57 AM
hanging start up with external drive	anarchicerror	Hardware	0	11-May-2008 04:21 AM
Need Help with wriitng Macro/code to rid unwanted data and retain specific data	pkji	All Other Software	1	07-May-2008 06:55 AM

Tag Cloud
access acer asus bios bsod computer crash desktop dns driver drivers error ethernet excel freeze gaming graphics hard drive hardware hdmi internet laptop malware memory monitor motherboard network printer problem ram registry repair router slow software sound trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Find the solution to yourcomputer problem!

Find the solution to your
computer problem!