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

--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

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