Additional controls

[Bob]

Hi Everyone:

In excel 2003, I was wondering if I create an add-in (.XLA) that has some
additional controls, for example a treeview or listview, would these
controls stay in the file or not. In other words, would my add-in work on
someone else's computer if they do not have these controls? If not any
suggestions?

Thanks for your help.

Bob

 

[Valmont]

These controls only stay in the file if the system of the other person has
the same set of controls registered.

I'll post an example, and then the solution:

I add a Microsoft Calendar control in my excel form or sheet. I send the
sheet to another system and open it there. But the control is missing and I
most likely will receive a warning message.

Resolution: The MS Calendar control (MSCAL.OCX) is installed only if MS
Access is installed.
If you don't want to install Access on that machine then register at least
the MSCAL control by doing the following:

1) Copy the mscal.ocx file (that's the control basically) to the Windows
system folder. Sytem32 on xp and such, winnt on windows 2000.
2) Register the control by opening the cmd console (type cmd in start ->
run).
3) Type REGSVR32 MSCAL.OCX

You will receive feedback whether the registration went successfully. Now
you can re-open the sheet and notice how the control is present again.

Good Luk,
Val