Run time error 438 MSCAL.OCX and Dates in Macro

M

Marvin

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

Marvin

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
 
M

Marvin

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

Problems with referenced mscal.ocx 3
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
VSTO C# add in Outlook.Appointment error 0
Run-time error 438 1
Run-time error 438 - using With 9
Run-Time Error 438 Outlook 5
Office add-in registration error - Component not correctly registered 0
Run Time Error 438 2

Top