macro as and moving files
 

I have been working on an excel file that was located on my desktop. I
elected to move it to a directory in C:/programs/whateverfolder

When i open the file located in the program directory and try to use the
macros that were written while the file was on the desktop i get an error
saying that macro x cannot be located and gives me the location of the
original excel xls file on the desktop.

How do i correct this problem. Is there a way to make the macros work where
ever that i put the xls file?

help???

--
dr chuck

macro as and moving files
 

forgot to click notify me...
--
dr chuck


"dr chuck" wrote:

I have been working on an excel file that was located on my desktop. I
elected to move it to a directory in C:/programs/whateverfolder

When i open the file located in the program directory and try to use the
macros that were written while the file was on the desktop i get an error
saying that macro x cannot be located and gives me the location of the
original excel xls file on the desktop.

How do i correct this problem. Is there a way to make the macros work where
ever that i put the xls file?

help???

--
dr chuck