Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie- Filename referencing in macros
I edited an Excel File with macros, saved a copy of the
file with a new filename, and then found the macros in the new file are attempting to call the procedures from the original file, and returning the error "file specified cannot be found", or something to that effect. Am I omitting something when I am saving a file with a new filename with macros? I can see all the macros in the new file when I check for them, but it's as though I need to remap the commandbuttons to the macros in the current file. Thanks in advance, Ellen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie- Filename referencing in macros
In the new file, select Edit - Links, then Change Source.
In the dialog box select the new file and OK. This will cause the buttons to look for the macros in the new file, assuming the macro names haven't changed. -- Hope this helps, James dot Becker at NCR dot com ~ ~ ~ :wq! "Ellen" wrote in message ... I edited an Excel File with macros, saved a copy of the file with a new filename, and then found the macros in the new file are attempting to call the procedures from the original file, and returning the error "file specified cannot be found", or something to that effect. Am I omitting something when I am saving a file with a new filename with macros? I can see all the macros in the new file when I check for them, but it's as though I need to remap the commandbuttons to the macros in the current file. Thanks in advance, Ellen |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie- Filename referencing in macros
Ellen;
Try this: Sub SaveIt() ActiveWorkbook.Save End Sub Regards, Jim Kobzeff "Ellen" wrote in message ... I edited an Excel File with macros, saved a copy of the file with a new filename, and then found the macros in the new file are attempting to call the procedures from the original file, and returning the error "file specified cannot be found", or something to that effect. Am I omitting something when I am saving a file with a new filename with macros? I can see all the macros in the new file when I check for them, but it's as though I need to remap the commandbuttons to the macros in the current file. Thanks in advance, Ellen |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie- Filename referencing in macros
Thank you! To Both of you! I'll check them out! Much
appreciated! Ellen -----Original Message----- I edited an Excel File with macros, saved a copy of the file with a new filename, and then found the macros in the new file are attempting to call the procedures from the original file, and returning the error "file specified cannot be found", or something to that effect. Am I omitting something when I am saving a file with a new filename with macros? I can see all the macros in the new file when I check for them, but it's as though I need to remap the commandbuttons to the macros in the current file. Thanks in advance, Ellen . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie- Filename referencing in macros
THANK YOU!
-----Original Message----- In the new file, select Edit - Links, then Change Source. In the dialog box select the new file and OK. This will cause the buttons to look for the macros in the new file, assuming the macro names haven't changed. -- Hope this helps, James dot Becker at NCR dot com ~ ~ ~ :wq! "Ellen" wrote in message ... I edited an Excel File with macros, saved a copy of the file with a new filename, and then found the macros in the new file are attempting to call the procedures from the original file, and returning the error "file specified cannot be found", or something to that effect. Am I omitting something when I am saving a file with a new filename with macros? I can see all the macros in the new file when I check for them, but it's as though I need to remap the commandbuttons to the macros in the current file. Thanks in advance, Ellen . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie- Filename referencing in macros
THANK YOU!
-----Original Message----- Ellen; Try this: Sub SaveIt() ActiveWorkbook.Save End Sub Regards, Jim Kobzeff "Ellen" wrote in message ... I edited an Excel File with macros, saved a copy of the file with a new filename, and then found the macros in the new file are attempting to call the procedures from the original file, and returning the error "file specified cannot be found", or something to that effect. Am I omitting something when I am saving a file with a new filename with macros? I can see all the macros in the new file when I check for them, but it's as though I need to remap the commandbuttons to the macros in the current file. Thanks in advance, Ellen . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Newbie on Macros | Excel Worksheet Functions | |||
Referencing a filename in a formula | Excel Discussion (Misc queries) | |||
The available macros list in XL; how to suppress filename from showing | Excel Discussion (Misc queries) | |||
Newbie: Excel Macros and Personal.xls | Excel Programming | |||
Disabling Macros After A Save To A Different Filename | Excel Programming |