Excel VBA problem - possibly ocx/dll issue

**elsvieta** · 07-01-2009, 12:21 AM

hi all,
I have a spreadsheet with some code in it - nothing more than a handfull of functions among which I have a calendar control.
This control gave me some trouble when running this spreadsheet on different machines - sometimes it seems the calendar dlls are older versions and I have to register the newer versions for the spreadsheet to work.

Now I am confronted with a new problem. I need to add one line of code to print some value in a cell.
I get the old version, open it, add the line, save it and I see the older version is around 300 KB, the new saved version of the spreadsheet is around 200 KB. Could this be related to the calendar control as well?

Excel 2002, XP SP3
Can anyone tell me what is happening?
Thanks,
elsvieta

**royUK** · 07-01-2009, 02:37 AM

The calendar controls can cause problems if it is not installed on a PC or an older version, there's some alternatives here

http://www.excel-it.com/free_addins.htm

I wouldn't think the control is responsible for the size issue

**elsvieta** · 07-02-2009, 12:06 AM

OK,
what else could cause the size problem? I don't remember seeing something like that ...
As a matter of fact, I tried to open the 300 K file on three different computers and they all saved a new version of 100 K less ...
Have no idea why?

Thanks,
elsvieta

**Leith Ross** · 07-02-2009, 01:41 AM

Hello elsvieta,

Excel tries to "guess" how much additional space you might need. I don't know all the factors that are considered in the decision process, but the user's system hardware and software come into play. It really isn't anything to worry about. If you have ever zipped a workbook, you've seen how much unused space there is in the workbook.

**royUK** · 07-02-2009, 02:20 AM

See this page & solution

**DonkeyOte** · 07-02-2009, 05:27 AM

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!