Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default How to compact an Excel file with VBA

Hello:

Each time I write the smallest of VBA codes, the size of
my excel file baloons? Any ideas why? Any thoughts on how
to compact the file?

Your help is appreciated.
-Neil
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,824
Default How to compact an Excel file with VBA

maybe you should try using Rob Bovey's codecleaner program.

You can find it at:
http://www.appspro.com/

It exports, deletes, imports the modules.

Neil Bhandar wrote:

Hello:

Each time I write the smallest of VBA codes, the size of
my excel file baloons? Any ideas why? Any thoughts on how
to compact the file?

Your help is appreciated.
-Neil


--

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 do I save an excel file to a rewritable compact disc? sbolton Excel Discussion (Misc queries) 4 November 25th 08 01:30 PM
Compact or Shrink down excel file James C. Excel Discussion (Misc queries) 3 June 18th 07 09:42 PM
HOW TO COMPACT AN EXCEL FILE CAPTGNVR Excel Discussion (Misc queries) 3 February 1st 07 07:34 PM
How to read Pocket Excel file in Compact framework Dhananjay Excel Discussion (Misc queries) 0 October 10th 06 11:59 AM
How to read Pocket Excel file in Compact framework Dhananjay Excel Discussion (Misc queries) 0 October 10th 06 11:59 AM


All times are GMT +1. The time now is 01:54 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"