T
tweacle
I have a macro which saves a workbook as a different name to the maste
copy that I am using by having this command.
'Application.ExecuteExcel4Macro ("save.as?()")
No problem with it saving as. I then have the macro to break the link
on the new renamed workbook and then return to the master copy. Th
problem is that despite writing the macro in the master copy it save
it in the renamed workbook. Is there anyway that I can keep it in th
master workbook cos I need to use the same macro every month.
If not is there anyway I can save the master copy as a renamed file an
then break the links on it but keeping the links on the master copy
copy that I am using by having this command.
'Application.ExecuteExcel4Macro ("save.as?()")
No problem with it saving as. I then have the macro to break the link
on the new renamed workbook and then return to the master copy. Th
problem is that despite writing the macro in the master copy it save
it in the renamed workbook. Is there anyway that I can keep it in th
master workbook cos I need to use the same macro every month.
If not is there anyway I can save the master copy as a renamed file an
then break the links on it but keeping the links on the master copy