Distributing Excel VBA code

[pachad]

This is my first attempt at VBA.

I received an Excel file (approx 8 mb) which contained a worksheet and a whole bunch of macros.

Using vba, I made the requested edits and saved (and edited, and saved, and edited and saved...) the file.

However, when I went to submit the file to my boss, I noticed that the file size had shrunk from ~8mb to ~60k.

What am I doing wrong?

The spreadsheet uses DDE, if that helps.

 

[fumei]

Don't know what is "wrong" yet? Are your edits properly there? Are the macros still there? While it does seems a rather drastic change in file size, that in itself, is not a wrongness.

Could you tell us what you have found that IS wrong?

Gerry
See my Paintings and Sculpture

 

[dhulbert]

Pachad.

The macro's included in yor workbook don't really make up that much of the file size. Unless you have huge amounts and I'm thingking 1000's of lines of code.
The reduction in size is more likely to be down to the edits you did.
Have you deleted cells, converted formulas to values, updated pivot tables etc
These are the sort of things that will change the file size.


I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[pachad]

Other than adding a single column and adding a module with 20 or so lines of code, no major changes.

None of the code seems to run on the client's machine, eventhough the old one worked perfectly, and the new one worked perfectly on mine...