[RESOLVED] Help..COuld not find the...
hi! can anybody please help me with my problem. I have an excel file with a button in it and when I click that button a form should appear but instead of a form an Error appears saying "COuld not load an object beacuase it is not available on this machine" and as I click "ok" from the Error MessageBox finally, the form appears but there's 1 object missing which the Datepicker, basically, my form consist of Textboxes, buttons and Datepicker. by the way, it is working on other machine. hope anybody can help me with this. thanks in advance!!!
Re: Help..COuld not find the...
I've already solved it..anyway, just for the sake of those who may encounter this problem i will share my solution.
Solution:
1. Copy (WIN XP) c:\windows\system32\mscomct2.ocx from the computer where the macro is working.
2. Paste the mscomct2.ocx file to c:\windows\system32 and register it by.
3. click 'Start' then 'run' then key-in 'regsvr32 c:\windows\system32\mscomct2.ocx' without the single quotation. and press enter.
*Note:There must be a confirmation saying 'DllRegisterServer in regsvr32 c:\windows\system32\mscomct2.ocx succeeded' or somthing like that. then you can now run you macro.