Run time error 438 MSCAL.OCX and Dates in Macro

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.
 
G

Guest

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
 
G

Guest

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

Run Time Error 438 2
Run-time error 438 1
Run-time error 438 - using With 9
Runtime error 438 4
Run-Time error 438 5
RUN-TIME ERROR 438 2
Run time error - 438 2
run-time error 438 1

Top