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

While distributed with Access, access if not required:

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

--
Regards,
Tom Ogilvy


"Benz" wrote:

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

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

"Tom Ogilvy" wrote:

While distributed with Access, access if not required:

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

--
Regards,
Tom Ogilvy


"Benz" wrote:

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

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" wrote:

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

"Tom Ogilvy" wrote:

While distributed with Access, access if not required:

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

--
Regards,
Tom Ogilvy


"Benz" wrote:

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

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" wrote:

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" wrote:

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

"Tom Ogilvy" wrote:

While distributed with Access, access if not required:

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

--
Regards,
Tom Ogilvy


"Benz" wrote:

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

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)





On Wed, 15 Oct 2008 05:06:01 -0700, JW_4222
wrote:

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" wrote:

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" wrote:

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

"Tom Ogilvy" wrote:

While distributed with Access, access if not required:

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

--
Regards,
Tom Ogilvy


"Benz" wrote:

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