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]