View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stan Stan is offline
external usenet poster
 
Posts: 3
Default Decompile Excel VBA code

Hello all,

I have been working in a large workbook 70+ worksheets. I was writing
code to duplicate a form(worksheet) and failed to set some objects to
nothing as I was testing the code. As a result the file bloated up to
17 MB from 4 MB.

There is a little known capability in MS Access to decompile a
database.
Create a shortcut and use the decompile switch:
"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE"
"D:\database.mdb" /decompile

Is there something similar in Excel or does anyone have any suggestion
to get the file back to it's original size?