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")
Is the code actually in the workbook or is it in your personal.xls?
Can you post it here?
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
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
That's why I never use the calendar control....portability.
http://vbaexpress.com/kb/getarticle.php?kb_id=543
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Posting Permissions
Reply With Quote
