Please help me
I have a following requirement,
we are doing attachment of excel file in mail body and sending it in mail.
i have to send attchment mail everyday, so i want to add excel sheet everytime in mail Excel file.
for an example,
Main Excel file contains name : book.xls and it contains sheet1. (for current date)
now on next date i want to add excel sheet in main Excel file (book.xls) instead of creating new excel file.
So, everyday sheet1, sheet2,sheet3,...,sheetn will be appened in main excel file book.xls and have to keep sheet name as current date name.