Calendar Control

B

Benz

Is there a calendar control user form or something that does the same thing,
that does not require Access to be on your computer?
 
B

Benz

It gave me an error that "Can not load object because not on this machine"
after installing the files at the bottom.
 
J

JW_4222

I've created the control manually, also downloaded and installed third party
controls. My question is: How do you distribute your form including the
calendar function regardless of what files the machine it is being used on?

Thanks,

Tom Ogilvy said:
But did you install the Calendar control? More than likely you did not.
About midway through this page (http://www.fontstuff.com/vba/vbatut07.htm) it
says:

[Follow this link for full instructions on downloading and installing the
mscal.ocx ActiveX Calendar Control file.]

--
Regards,
Tom Ogilvy


Benz said:
It gave me an error that "Can not load object because not on this machine"
after installing the files at the bottom.
Click to expand...
Click to expand...
 
C

Chip Pearson

Each machine on which the file will be used will need to have the
Calendar control. If you use an installer program to create a
distributable exe file (e.g., Setup.exe created with InstallShield or
SetupFactory), you can include the Calendar.ocx file in the
distribution package. If you are simply distributing the xls file, you
iwll have to distribute the MSCal file along with the xls file and
then have the user register that contol on their system. You can
automate this with code like the following. It allows the user to
browse for the MSCal file (starting in C:\Windows\System32) and then
it calls RegSvr32 to register the control.


Sub AAA()
Dim FName As String
Dim SaveDir As String
SaveDir = CurDir
ChDrive Environ("SystemRoot")
ChDir Environ("SystemRoot") & "\System32"
FName = Application.GetOpenFilename( _
"Controls (*.ocx),*.ocx", 1, "Install Calendar Control")
If StrPtr(FName) = 0 Then
ChDrive SaveDir
ChDir SaveDir
Exit Sub
End If
If Dir(FName, vbNormal) = vbNullString Then
ChDrive SaveDir
ChDir SaveDir
Exit Sub
End If
Shell "regsvr32 " & Chr(34) & FName & Chr(34) & " /s"
MsgBox "MSCal (file = '" & FName & "') installed."
End Sub

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)





I've created the control manually, also downloaded and installed third party
controls. My question is: How do you distribute your form including the
calendar function regardless of what files the machine it is being used on?

Thanks,

Tom Ogilvy said:
But did you install the Calendar control? More than likely you did not.
About midway through this page (http://www.fontstuff.com/vba/vbatut07.htm) it
says:

[Follow this link for full instructions on downloading and installing the
mscal.ocx ActiveX Calendar Control file.]

--
Regards,
Tom Ogilvy


Benz said:
It gave me an error that "Can not load object because not on this machine"
after installing the files at the bottom.

:

While distributed with Access, access if not required:

http://www.rondebruin.nl/calendar.htm

--
Regards,
Tom Ogilvy


:

Is there a calendar control user form or something that does the same thing,
that does not require Access to be on your computer?
Click to expand...
Click to expand...
Click to expand...
 
Top