Thread: Compact
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jake Marx[_3_] Jake Marx[_3_] is offline
external usenet poster
 
Posts: 860
Default Compact

Hi Steve,

Steve wrote:
I have created an Excel solution for a client, but with User Forms and
modules the file has gotten rather large. I realize there is no
compact and repair, as in Access, within Excel. Can anyone give me
instructions on how to export modules into a new spreadsheet file, or
what is the best way to try and reduce the file size.


You could try running Rob Bovey's VBA Code Cleaner:

http://www.appspro.com/Utilities/Utilities.htm

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]