Hi -

I have created this macro consisted of several forms for user entry and a module for processing the data entry, and a calendar control to display calendar to user to select a date.

We are testing this macro as users. However, several of us located at Belgium office came into an error when open this excel file. The error message says "Can not load this object because it is not available in this machine". I did not do any set up changes for users over here in the US. So I am wondering if this has anything to do with the setup in general? And how should I overcome the problems so that users overseas can use this macro too?

Do I need to ensure the calendar control is installed on each machine? but I did not modify any setup for users over here?

Kathy

I am assuming the Calendar control being used is the calendar Control 9.0.
If so then in the VBA editor go to Tools...Additional Controls... and place a check mark next to the above item.

This should resolve the issues in the future. It may need to be repeated for each PC to be used.

Matthew

Matthew -

It is Calendar control 9.0, I was referring to. However, my users oversea (at Belgium) don't even see it as an option to choose from VBE-> Tools->References. Wondering if this has an Excel application installation related issue?

What also puzzles me is that I didn't turn on the calendar control for the users here (in US) and the macro is running fine with their pc.

I was trying to avoid date conversion headache by using the calendar control so that the users can click on the pop-up calendar instead of typing it. Wondering if there is other way of handling this if I still cannot figure out how to turn on calendar control?

Kathy

Ask your Belgium colleagues to look for a calender control in their native language. It probably doesn't have the english name.

What I mean is, ask them to look in the Control Toolbox from the Excel View menu. From the extended objects they can select in the bottom item of the Toolbox menu (More controls...), they should be able to find a localized name for the Calendar control.

If they're running the macro recorder they should also get the vba code name for the control, which I believe should be the same as yours. But you'd then know if it's accessible at all.

When I look in the VBE References i'm not able to find the Microsoft Calendar Control, unless I have placed a Calendar control in a sheet (MSCAL.OCX).

Maybe you can get around the problem by adding the reference to the control before you reference it in your code.

Application.VBE.ActiveVBProject.References.AddFrom File "C:\Windows\system32\MSCAL.OCX"

does everyone have the same excel version?

We had the problem solved as described below. Origionally, we didn't even see calendar control as an option to select in VBA-Editor-Reference-Add controls. In order to have the selection option, the helpdesk loaded the calendar control by doing the following.

Go to start - run and type cmd
Type commando cd\winnt\system32 and enter
Type commando in regsvr32 mscal.ocx and enter

Open Excel and go to Tools - Macro - Visual Basic Editor
Go to Microrsoft Visual Basic and Tools - References
Browse to C:\WINNT\SYSTEM32 and look for mscal.ocx (ensure that under Files Type "ocx" is selected).
Clinck Open and it should appear under the references listed now.

Kathy