Sep 11, 2013 I was trying to use Microsoft monthview control and it is not shown on the additional controls. Then I download MSCOMCT.cab, extract, copy and paste to both c: windows sysWOW64 mscomct2.ocx and c: windows system32 mscomct2.ocx. After that I use regsvr32 to run both of them with administor seperately. Re: I cant find 'Microsoft Monthview Control' Thanks for the replys, unfortunately the command window options didn't resolve the problem, I have MSCOMCT2.OCX in sys32 and it loads but wont run, I can not get the Monthview Control feature to work.
. On the Developer tab, in the Controls group, click Insert, and then under ActiveX Controls, select a control, or click More Controls to view all the available ActiveX controls, and then select a control. Click the worksheet location where you want the ActiveX control to appear. To edit the control, make sure that you are in design mode. On the Developer tab, in the Controls group, turn on Design Mode. To specify the control properties, on the Developer tab, in the Controls group, click Properties.
Click the ActiveX control that you want to register. Make sure that you are in design mode. On the Developer tab, in the Controls group, turn on Design Mode. On the Developer tab, in the Controls group, click Insert, and then under ActiveX Controls, click More Controls. At the bottom of the More Controls dialog box, click Register Custom. In the Register Custom Control dialog box, locate the folder that contains the control file (.ocx file name extension) or dynamic link library file (.dll file name extension) for the control that you want to register. Select the file for your control, and then click Open.
Need more help? You can always ask an expert in the, get support in the, or suggest a new feature or improvement on.
I've developed a tool using VBA in Excel 2002 (XP) and I have used the Microsoft MonthView Control 6.0 (SP6). I need the workbook and attached form to work on a Windows XP machine that doesn't have MSCOMCT2.ocx installed. Due to administrator restrictions on each machine (and the resources required to update each and every machine with this file) I am unable to run as I get an 'object missing' error when I run the userform. Is there any way I can use the MonthView control without having to install it on each machine. Hope someone can help. Try a web search on 'vba calendar'.
There's lots out there. I can't vouch for any of them (I haven't tried any), but I do suggest before you download any that you make sure they'll work with your date format (eg mm-dd-yy vs dd-mm-yy), and as most of them are downloaded in Excel format it would be wise to run a virus scan on them before opening (although that won't save you from nasty code). I've used the Calendar control successfully on a fairly tight security network. The reason I was able to is that the Calendar Control is standard with Office Professional (and also with stand-alone Access, but I think not with stand-alone Excel), and all our PCs have Office Pro licenses, so that control was already available. Another possibility might be the standard Windows MonthCalendar and DateTimePicker controls. These are system controls, so they won't be as straightforward as using Excel or Office controls. I'm sure it's possible to access them via VBA, but I've never done so and am unlikely to be able to offer much advice should you go that path. To use the MonthView control in your application, you must add the MSCOMCT2.OCX file to the project.
When distributing your application, install the MSCOMCT2.OCX file in the user's Microsoft Windows System or System32 directory. That certainly sounds as if it has to be installed. A quick web search seems to confirm this. If all the PCs have Office installed, though, they probably all have the Calendar control.
Would that serve your purpose, or are you using some functionality of MonthView that calendar doesn't have? NB if they are running different versions of office this can get messy, as the name of the library includes the version number, so you have to reference all the versions in your project, with higher numbered versions taking precedence, to ensure it will work on all. Try a web search on 'vba calendar'. There's lots out there. I can't vouch for any of them (I haven't tried any), but I do suggest before you download any that you make sure they'll work with your date format (eg mm-dd-yy vs dd-mm-yy), and as most of them are downloaded in Excel format it would be wise to run a virus scan on them before opening (although that won't save you from nasty code).
I've used the Calendar control successfully on a fairly tight security network. The reason I was able to is that the Calendar Control is standard with Office Professional (and also with stand-alone Access, but I think not with stand-alone Excel), and all our PCs have Office Pro licenses, so that control was already available. Another possibility might be the standard Windows MonthCalendar and DateTimePicker controls. These are system controls, so they won't be as straightforward as using Excel or Office controls. I'm sure it's possible to access them via VBA, but I've never done so and am unlikely to be able to offer much advice should you go that path.