Excel-> Method 'Value' of object '_DMsacal70' failed

[tav1035]

Has anyone ever seen this error->
Microsoft Visual Basic
Run-time error '-2147319765 (8002802b)':
Method 'Value' of object '_DMsacal70' failed

I set up a calendar macro in excel using thread68-676537. It runs fine on my computer, but won't run on an identical computer.. both running Win2000, Office2002.

Debug points to->
Sub OpenCalendar()
' Displays the UserForm and calendar
' Shortcuts should be made to this procedure
->frmCalendar.Show
End Sub


I searched the web and could only find one reference to this error, but there was no resolution.
tav

 

[VBAjedi]

Does your form use a calendar control? If so, it may not be installed on the second computer (for whatever reason). If that's not it, we'd probably need to see the code of OpenCalendar().



VBAjedi

 

[VBAjedi]

More thoughts:

Just checked out that website. Their tutorial has you building your calendar in your Personal.xls workbook. That's great if you want it accessible in any workbook on your computer, but it's bad if you want it accessible on other computers. The code should be written in the actual workbook you plan to distribute to other computers.

And from that web site:

NOTE: The Calendar Control is an ActiveX control (actually a file called mscal.ocx) supplied with Microsoft Office. It is normally installed with a standard installation of Microsoft Office, Excel or Access, but if you can't find it on the list you will need to get hold of a copy. If you are distributing your file, or planning to use it on more than one computer, you will also need to make sure that the host computer has the mscal.ocx file installed. You will find it on the CD that your copy of Excel came on, or you can download a copy from the Microsoft web site at:

http://www.microsoft.com/officedev/freestuff/mscaldl.htm.

NOTE: If after downloading and installing the Calendar Control file it does not appear on the Additional Controls menu, you need to "register" it so that Windows knows that it is there. To do this go to Start > Run and enter: regsvr32 mscal.ocx then press Enter.



VBAjedi

 

[tav1035]

VBAjedi,
Friday will be the next available time to test this.
Down at the bottom of that website

http://www.fontstuff.com/vba/vbatut07.htm

I downloaded the Excel Calendar Workbook.zip.
This file worked straight out of the zip, but wouldn't run on the other computer.
I have a feeling that the other computer needs that mscal.ocx.
thanks, until Friday
tav