Excel file opening macro

open excel, on the Tools menu, click Macro, then Macros. a list of all macros embedded within that particular worksheet will appear. highlight the macro you want to change and click the edit button.

the visual basic editor pops up with whatever codes in there for the macro. somewhere in the code will be the path of the file you open everytime you hit the macro button (smile). change the path to the new location.

first, copy whatever code you see when you opened visual basic and copy/save it as a word doc in case you change something that needs to be changed back.