View Full Version : could not load an object because it is not available on this machines

06-28-2007, 12:15 PM
my workbook cannot be open without errors on other machines.
1st I get "could not load an object because it is not available on this machines"

then "method or data method not found and it stops at line code:
ImportForm.txtDate.Value = Sheet1.Range("j2")

06-28-2007, 03:12 PM
Is the code actually in the workbook or is it in your personal.xls?
Can you post it here?

06-28-2007, 07:25 PM
The code is in the workbook. I figured out the issue bot not the problem. I've got a work around for now. maybe you might have a suggestion. Here's the issue:
it's the calender form ( mscal.ocx) all the pc have this reference. however the calender give it the error. when i remove the calender and just it a simple text box, all works fine. I'd rather have the calender as it looks better

06-28-2007, 07:34 PM
That's why I never use the calendar control....portability.

06-28-2007, 07:40 PM