I have an excel file which has some data in sheet1. I want to write a macro to perform certain activities:
1. Copy all the data in sheet1.
2. Invoke another instance of Excel application
3. paste all the data including headers from 1.) into that new workbook's sheet1.
4. Save the new workbook under specified drive "c:\desktop\abc.xlxs"