ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   remove VBA codes while saving (https://www.excelbanter.com/excel-programming/411430-remove-vba-codes-while-saving.html)

SHETTY

remove VBA codes while saving
 
Dear Friends

Please tel me how to save copy of excel file through vba code (Modules if
any the files must be removed while saving the file)


Please guide


Ramesh Shetty
Mangalore



Dave Peterson

remove VBA codes while saving
 
Chip Pearson has lots of notes/examples he
http://www.cpearson.com/excel/vbe.aspx

Personally, I'd rather copy the data to worksheets in a different workbook
(maybe based on a template that was set up the way I wanted) and not have to
remove any code.



SHETTY wrote:

Dear Friends

Please tel me how to save copy of excel file through vba code (Modules if
any the files must be removed while saving the file)

Please guide

Ramesh Shetty
Mangalore


--

Dave Peterson


All times are GMT +1. The time now is 08:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com