Run time error 438 MSCAL.OCX and Dates in Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On one of my laptops I am getting the following message...
Run Time Error 438
Object does not support this property or method

the failing macro line is...
Activesheet.calendar1.value = Date

There is a calendar control called calendar1 on the sheet and MSCAL.OCX and
other MSCAL objects are in the office11 folder. I do not have this problem on
my other laptop. Both machines were recently bought. The laptop from Dell is
the one that is failing on this command.
 
Activesheet is really ActiveSheet(Sorry for the typo)
On the working laptop the follow two commands work and both fail on the
other laptop

Activesheet.calendar1.value = Date
Activesheet.calendar1.Today
 
Problem corrected by registering MSCAL.OCX using regsvr32 mscal.ocx

Does anyone know how to register this application within a macro?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

mscal problem in excel 0
mscal.ocx problems 2
Calendar object in Excel problem - mscal.ocx 0
Method Value of object Calendar failed 1
Run-time error 438 1
Run Time Error 438 2
RUN-TIME ERROR 438 2
Runtime error 438 4

Back
Top