rani_149
October 22nd, 2001, 01:44 AM
I have developed a template, but am a bit confused about how the events occur
What I want is that when the user makes changes in the template and clicks on the save button, automatically the exsisting template must be saved as an excel file
e.g in my template ("TrySave.xlt")I write in the event workbook_beforeSave
thisworkbook.Saveas("Try1.xls")
However,it gives me an error and closes the excel application itself...what is happening exactly.....
Aslo what should I do to solve my problem????
What I want is that when the user makes changes in the template and clicks on the save button, automatically the exsisting template must be saved as an excel file
e.g in my template ("TrySave.xlt")I write in the event workbook_beforeSave
thisworkbook.Saveas("Try1.xls")
However,it gives me an error and closes the excel application itself...what is happening exactly.....
Aslo what should I do to solve my problem????