PDA

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



ltworf13
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")

lucas
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?

ltworf13
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

lucas
06-28-2007, 07:34 PM
That's why I never use the calendar control....portability.
http://vbaexpress.com/kb/getarticle.php?kb_id=543

lucas
06-28-2007, 07:40 PM
http://www.vbaexpress.com/forum/showthread.php?t=10914