Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro link issue when saving as new filename.
I created a custom menu with options to trigger macros. The only problem is however, excel is automatically converting these to (xlFilename)!(MacroName). They run fine in that file, but whenever I run the report for the file, and save for that daily version, the macro links still refer to the original file and I do not want the original file to be opened by excel just to run simple navigational macros.
At first I was just going to make these standalone macros, however, the end user will not have access to this directory. Is there ANY possible way to make excel link to (MacroName) rather than including the filename, and not try to update this link when it is saved as a new file. Just to note, this toolbar is attached to the worksheet. Let me know if anyone can help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro/Link Issue (apologies for cross-posting) | Links and Linking in Excel | |||
Saving XLS workbook with set filename | Excel Discussion (Misc queries) | |||
Saving with date in filename | Excel Programming | |||
Saving filename same as import filename | Excel Programming | |||
Saving Cell value as filename | Excel Programming |