Macro mapping/location macro changing
Posted by Daniel on November 26, 2001 5:27 AM
I have mapped a macro to a custom button, in the macro Im using a save as command.
ChDir ("C:\SSS-SpreadSheet") 'Changes directory
NewNameFileName = Manifest(1, 1) & ".xls"
The only thing wrong with this is the macro is saving to the new file name instead of staying with the excel sheet I have made as a template (C:\Program Files\Microsoft Office\Templates\Spreadsheet Solutions\SSS.xlt).
I there a way to save a macro to a place and map that place to the custom button, so the macro is not re-associated with the new .xls?