Kiran Kumar
New Member
Hi there,
I have written a macro and assigned to a button on the excel. Once I clik on the button, the current excelworkbook goes as an email.
Now, the challenge is with the size of the file. As its a huge file, is there any way that once I click on the button it automatically zip the file and send.
Appreciate if you could share the code to zip the current file.
Regards,
KK
I have written a macro and assigned to a button on the excel. Once I clik on the button, the current excelworkbook goes as an email.
Now, the challenge is with the size of the file. As its a huge file, is there any way that once I click on the button it automatically zip the file and send.
Appreciate if you could share the code to zip the current file.
Regards,
KK