Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can i remove the lotus formating codes when copying? BJRParker Excel Discussion (Misc queries) 0 April 8th 08 10:00 AM
How can i remove the lotus formating codes when copying? BJRParker Excel Discussion (Misc queries) 0 April 8th 08 06:20 AM
Remove content when saving / loading spreadsheet EZdoesIT Excel Worksheet Functions 4 November 13th 06 03:42 PM
remove vba and functions when saving worksheet john tempest[_2_] Excel Programming 5 January 13th 06 05:02 PM
remove query table when saving Michael Excel Programming 3 September 8th 05 10:04 AM


All times are GMT +1. The time now is 11:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"