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?
 
Back
Top