LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 747
Default Programmactically add calendar control to userform

Hi all,

I'm trying to write a patch for a program of mine. The program uses Calendar
Control 9.0 and is installed on a network drive. A copy of MSCal.OCX has been
added to the same folder. The program is intended to be used by several
people in the office.

Unfortunately, apparently many don't have the calendar control file and/or
don't have it registered. This causes an error message and causes the
calendar control to disappear from the userform when the program is opened. I
have successfully fixed the problem manually for one computer but it is
impractical to do this for the entire office. It is uncertain how many and
whom will end up using it.

I'm hoping I can write a patch that will check for the calendar control and,
if not found, register the file (on the network drive) and programmatically
add it to the userform. I know how to use the Shell command to automatically
run Regsvr32 and register the calendar control. I also know how to
programmatically add a reference to the VBA Extensibility Library. However,
I've been unsuccessful at programmatically adding the control to the userform.

Hoping someone can help or suggest a better solution.

Best regards,
Greg

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Enter date in userform using Calendar Control Scotty9349 Excel Discussion (Misc queries) 1 March 4th 09 07:02 PM
Control disappeared problem - specifically, the Calendar Control JMMach[_2_] Excel Programming 0 December 16th 05 01:53 AM
Control Sequence from Userform Control Nigel Excel Programming 3 December 29th 04 01:25 PM
Calendar Control: Can't exit design mode because control can't be created Rone Excel Programming 0 May 24th 04 04:01 PM
How to use Microsoft Calendar Control 9.0 on a Userform Anupam Sharma Excel Programming 4 August 27th 03 06:19 PM


All times are GMT +1. The time now is 04:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"