Compact
 

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.

Thanks,

Compact
 

Hi Steve,

For the Code modules consider using Rob Boveys's CodeCleaner addin which is
freely downloadable at:

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


For the worrksheets, see Debra Dalgleish' advice on resetting the UsedRange
at:

http://www.contextures.com/xlfaqApp.html#Unused


---
Regards,
Norman



"Steve" wrote in message
...
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.

Thanks,

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]

Compact
 

Ok, thanks. I have downloaded the CodeCleaner and installed it, but how do I
make it run? How does it clean the code, so to speak?


"Norman Jones" wrote:

Hi Steve,

For the Code modules consider using Rob Boveys's CodeCleaner addin which is
freely downloadable at:

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


For the worrksheets, see Debra Dalgleish' advice on resetting the UsedRange
at:

http://www.contextures.com/xlfaqApp.html#Unused


---
Regards,
Norman



"Steve" wrote in message
...
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.

Thanks,

Compact
 

Hi Steve,

Run the downloaded exe file which invokes an automatic installation process.

The CodeCleaner may then be called from the VBA or Excel Tools menus.

If you are using xl2002 or later, note Rob's instructions:

'===============================

Note to Excel 2002 (XP) and Excel 2003 Users
There is a new level of code security in Excel 2002 and higher versions that
you must disable in order for the Code Cleaner to operate. Choose Tools
Macro Security from the Excel menu and click the Trusted Sources tab. At
the bottom of this tab you'll see a checkbox labeled Trust Access to Visual
Basic Project. Check this option and click OK to enable the Code Cleaner to
run.
'===============================

---
Regards,
Norman



"Steve" wrote in message
...
Ok, thanks. I have downloaded the CodeCleaner and installed it, but how
do I
make it run? How does it clean the code, so to speak?


"Norman Jones" wrote:

Hi Steve,

For the Code modules consider using Rob Boveys's CodeCleaner addin which
is
freely downloadable at:

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


For the worrksheets, see Debra Dalgleish' advice on resetting the
UsedRange
at:

http://www.contextures.com/xlfaqApp.html#Unused


---
Regards,
Norman



"Steve" wrote in message
...
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.

Thanks,