I am creating a button on a workbook that is displayed on a custom toolbar. The workbook is a template. All I would like for that button to do is perform a saveas.
I have this code:
Application.Dialogs(xlDialogSaveAs).Show
Let's say for example, that the first time I am on the template, I hit the button and save a file called 'test.xls'. Then, for whatever reason, someone no longer needs 'test.xls' so they delete it. The next time the saveas button is hit on the original template, I receive an error stating that 'test.xls' could not be found etc etc. Why is it looking for the last saveas and how can I get it to stop doing this? Thanks in advance.
I have this code:
Application.Dialogs(xlDialogSaveAs).Show
Let's say for example, that the first time I am on the template, I hit the button and save a file called 'test.xls'. Then, for whatever reason, someone no longer needs 'test.xls' so they delete it. The next time the saveas button is hit on the original template, I receive an error stating that 'test.xls' could not be found etc etc. Why is it looking for the last saveas and how can I get it to stop doing this? Thanks in advance.
