ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2007 MS Common Controls (https://www.excelbanter.com/excel-programming/431307-excel-2007-ms-common-controls.html)

John Howard[_2_]

Excel 2007 MS Common Controls
 
I have two PC's each loaded with Excel 2007 and both updated to the same SP2
level.
One machine allows Reference to 'Microsoft Windows Common Controls-2
6.0(SP6)' whilst the second machine has this Reference missing.

I assume that the missing Reference comes from an ocx file.
Could anyone explain where this file comes from if not from within Office /
Excel updates.

Also am I correct in assuming that this Reference controls the Date / Time
Picker and MonthView Control ActiveX tools?
--
Regards
John Howard
Sydney, Australia

Jacob Skaria

Excel 2007 MS Common Controls
 
--Common controls are mscomctl.ocx and comctl32.ocx which usually comes along
with Microsoft Visual Basic 6.0 or Microsoft Visual Studio 6.0

--Date/Time Picker and MonthView Control are part of a group of ActiveX
controls MSCOMCT2.OCX. You can download this from the below location

http://activex.microsoft.com/controls/vb6/MSCOMCT2.CAB

If this post helps click Yes
---------------
Jacob Skaria


"John Howard" wrote:

I have two PC's each loaded with Excel 2007 and both updated to the same SP2
level.
One machine allows Reference to 'Microsoft Windows Common Controls-2
6.0(SP6)' whilst the second machine has this Reference missing.

I assume that the missing Reference comes from an ocx file.
Could anyone explain where this file comes from if not from within Office /
Excel updates.

Also am I correct in assuming that this Reference controls the Date / Time
Picker and MonthView Control ActiveX tools?
--
Regards
John Howard
Sydney, Australia


John Howard[_2_]

Excel 2007 MS Common Controls
 
Many thanks for that Jacob.
You have saved what little sanity I have left. :-)
--
Regards
John Howard
Sydney, Australia


"Jacob Skaria" wrote:

--Common controls are mscomctl.ocx and comctl32.ocx which usually comes along
with Microsoft Visual Basic 6.0 or Microsoft Visual Studio 6.0

--Date/Time Picker and MonthView Control are part of a group of ActiveX
controls MSCOMCT2.OCX. You can download this from the below location

http://activex.microsoft.com/controls/vb6/MSCOMCT2.CAB

If this post helps click Yes
---------------
Jacob Skaria


"John Howard" wrote:

I have two PC's each loaded with Excel 2007 and both updated to the same SP2
level.
One machine allows Reference to 'Microsoft Windows Common Controls-2
6.0(SP6)' whilst the second machine has this Reference missing.

I assume that the missing Reference comes from an ocx file.
Could anyone explain where this file comes from if not from within Office /
Excel updates.

Also am I correct in assuming that this Reference controls the Date / Time
Picker and MonthView Control ActiveX tools?
--
Regards
John Howard
Sydney, Australia



All times are GMT +1. The time now is 12:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com