I have designed a complex Excel spreadsheet app in which I am not the end
user that uses heavy vba including a calendar control. It was designed with
Excel 2003 and will be used on PCs with Excel 2003 and XP. I demonstrated the
app on a PC in which everything worked fine, however when I saved it to the
end user's PC it rejected the app because of a control not installed on the
machine.

Do we really have to do some preliminary installation on each PC using this
app because of the calendar control? Shouldn't the control operate on any PC
using the app?

Sam

Sam

The Caledar Control is mscal.ocx and is installed only if the version of MS
Office used contains Access.

You can download mscal.ocx from here.

http://www.fontstuff.com/vba/vbatut07.htm


Gord Dibben MS Excel MVP

On Thu, 16 Aug 2007 18:10:27 -0700, Sam wrote:

I have designed a complex Excel spreadsheet app in which I am not the end
user that uses heavy vba including a calendar control. It was designed with
Excel 2003 and will be used on PCs with Excel 2003 and XP. I demonstrated the
app on a PC in which everything worked fine, however when I saved it to the
end user's PC it rejected the app because of a control not installed on the
machine.

Do we really have to do some preliminary installation on each PC using this
app because of the calendar control? Shouldn't the control operate on any PC
using the app?

Sam