Moving file confuses macros

pilot · Apr 16th, 2002, 07:04 AM

I have developed a file in Excel 97 on my local PC that contains about 20 Subs all located in "This Workbook". I moved the file to a network where it is opened in Excel 2002 (OfficeXP). When attempting to execute any of the macros, an error box opens saying that a file with the same name is already open. None of the macros points to any file by name or path but obviously there is something doing that. I'd be grateful for ideas.

pilot · Apr 16th, 2002, 10:40 AM

I might have figured this out. I could run any of the macros from Alt-F8. Seems the macros assigned to my custom toolbar buttons were still pointing to the same file name on the a: drive. I can reassign all the macros to the custom toolbar buttons but is there an easier way?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 07:04 AM	#1
pilot Board Regular Join Date: Feb 2002 Location: Houston, TX Posts: 303	I have developed a file in Excel 97 on my local PC that contains about 20 Subs all located in "This Workbook". I moved the file to a network where it is opened in Excel 2002 (OfficeXP). When attempting to execute any of the macros, an error box opens saying that a file with the same name is already open. None of the macros points to any file by name or path but obviously there is something doing that. I'd be grateful for ideas.

Apr 16th, 2002, 10:40 AM	#2
pilot Board Regular Join Date: Feb 2002 Location: Houston, TX Posts: 303	I might have figured this out. I could run any of the macros from Alt-F8. Seems the macros assigned to my custom toolbar buttons were still pointing to the same file name on the a: drive. I can reassign all the macros to the custom toolbar buttons but is there an easier way?