Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 3rd, 2004, 09:37 AM
Authorized User
 
Join Date: Jun 2003
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default Excel VB workbook increasing in size

Hi --

  I am developing an excel vba application. As I continue to edit and save, the size of the xls file continues to increase. It is now at 2 mb. If I export all the vba files and then reimport into a new workbook, the file size decreases to .5 mb and works just fine. Is there any way to prevent the increase? If not, is there any way to automate the export/import process?

Thanks,

Barry

 
Old December 7th, 2004, 04:23 PM
Authorized User
 
Join Date: Jul 2004
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Dear Barry,

Go to the site www.appspro.com and download the VBA Code Cleaner Add-in.
I used it for a couple of months now for cleaning very big Excel files
and never had any problem with this great programm.
By the way they have more great and free utilities.

Succes






Similar Threads
Thread Thread Starter Forum Replies Last Post
Increasing the imageable size when printing nilsnorden BOOK: Beginning Java 2, JDK 5 Edition 0 February 23rd, 2007 11:19 AM
XPATH Help, Please- Excel XML Workbook jftaylor BOOK: XSLT Programmer's Reference, 2nd Edition 2 September 28th, 2006 08:47 PM
Display Excel Workbook in browser roopsk C++ Programming 0 August 8th, 2006 06:34 AM
Closing Excel Workbook rekha_jsr Excel VBA 0 July 9th, 2005 02:40 AM
Saving Excel workbook with new filename tsegal20 Excel VBA 1 May 21st, 2004 01:55 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.