even when i am not usig savecopyas() and save (*) method then there is no. problem my excel sheet is generated but 2 copy of excel sheet is open .
Excel Work book
what does WorkBook.savecopyas() method do.?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Sunny SharmaPosted Jul 6, 2013, 2:57 AM
SaveCopyAs() method saves the file live the Save() method do but, the usage are different. We use SaveCopyAs() method at times when an existing workbook is opened and doesn't need to be modified but still demands to save modified data somewhere else.
Hope you got the point.
Cheers!