[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

Location of mscal.ocx

Mickey Authement

12/18/2006 6:52:00 PM

I know this is not strictly and Excel question, but it does involve an
application I am developing in Excel. I used mscal.ocx (version 11) on a
userform and when I look at the references it is located in c:\Program
Files\Microsoft Office\Office 11...no problem. Some of my users do not have
this control, so when I Googled for more info, most of what I found says
that it should be installed in C:\Windows\System32 (I do have version 8 of
mscal.ocx located there). My question is this: does it matter where it is
installed/registered? If users have it installed/registered in system32
will they be able to open my .xla even though it is installed/registered in
Office 11 on my computer? Would they still use regsvr32 mscal.ocx to
register it no matter where it is located? Should I unregister/delete
version 8 and move/re-register version 11 to the system32 folder? Thanks
for your help (btw, I am using WinXP, Office 2003).


4 Answers

Gord Dibben

12/18/2006 7:29:00 PM

0

mscal.ocx is installed only if the version of MS Office used contains Access.

You can download mscal.ocx from here.

http://www.fontstuff.com/vba/vb...


Gord Dibben MS Excel MVP

On Mon, 18 Dec 2006 13:51:44 -0500, "M. Authement" <mautheme@kcc.com> wrote:

>I know this is not strictly and Excel question, but it does involve an
>application I am developing in Excel. I used mscal.ocx (version 11) on a
>userform and when I look at the references it is located in c:\Program
>Files\Microsoft Office\Office 11...no problem. Some of my users do not have
>this control, so when I Googled for more info, most of what I found says
>that it should be installed in C:\Windows\System32 (I do have version 8 of
>mscal.ocx located there). My question is this: does it matter where it is
>installed/registered? If users have it installed/registered in system32
>will they be able to open my .xla even though it is installed/registered in
>Office 11 on my computer? Would they still use regsvr32 mscal.ocx to
>register it no matter where it is located? Should I unregister/delete
>version 8 and move/re-register version 11 to the system32 folder? Thanks
>for your help (btw, I am using WinXP, Office 2003).
>

Mickey Authement

12/18/2006 7:53:00 PM

0

Thanks Gord. Any thoughts on my other questions about where the control
should be installed/registered and whether it matters if this location is
different from one machine to the next?


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:3rqdo2tts2dounm5pl4dbbv6869ugnd0v2@4ax.com...
> mscal.ocx is installed only if the version of MS Office used contains
> Access.
>
> You can download mscal.ocx from here.
>
> http://www.fontstuff.com/vba/vb...
>
>
> Gord Dibben MS Excel MVP
>
> On Mon, 18 Dec 2006 13:51:44 -0500, "M. Authement" <mautheme@kcc.com>
> wrote:
>
>>I know this is not strictly and Excel question, but it does involve an
>>application I am developing in Excel. I used mscal.ocx (version 11) on a
>>userform and when I look at the references it is located in c:\Program
>>Files\Microsoft Office\Office 11...no problem. Some of my users do not
>>have
>>this control, so when I Googled for more info, most of what I found says
>>that it should be installed in C:\Windows\System32 (I do have version 8 of
>>mscal.ocx located there). My question is this: does it matter where it is
>>installed/registered? If users have it installed/registered in system32
>>will they be able to open my .xla even though it is installed/registered
>>in
>>Office 11 on my computer? Would they still use regsvr32 mscal.ocx to
>>register it no matter where it is located? Should I unregister/delete
>>version 8 and move/re-register version 11 to the system32 folder? Thanks
>>for your help (btw, I am using WinXP, Office 2003).
>>
>


Gord Dibben

12/18/2006 9:13:00 PM

0

If you went to the site I posted and clicked the link to download the file you
would have seen this message.........

Copy the File to the Correct Folder

After downloading the file, unzip it and copy the mscal.ocx file (and its
associated help file if you require it) to the correct location on your
computer. This location depends upon which version of Windows you are using:

For Windows 95, 98 and ME this is C:\Windows\System

For Windows NT, 2000, XP it is C:\Windows\System32

Installations of Windows can vary so check for the correct location of the
System or System32 folder before you proceed.

Register the Control

The final step is to tell the Windows Registry that you have installed the file.
This ensures that your programs can find it. Click Start then Run and type:
regsvr32 mscal.ocx and click OK:


Gord

On Mon, 18 Dec 2006 14:52:42 -0500, "M. Authement" <mautheme@kcc.com> wrote:

>Thanks Gord. Any thoughts on my other questions about where the control
>should be installed/registered and whether it matters if this location is
>different from one machine to the next?
>
>
>"Gord Dibben" <gorddibbATshawDOTca> wrote in message
>news:3rqdo2tts2dounm5pl4dbbv6869ugnd0v2@4ax.com...
>> mscal.ocx is installed only if the version of MS Office used contains
>> Access.
>>
>> You can download mscal.ocx from here.
>>
>> http://www.fontstuff.com/vba/vb...
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Mon, 18 Dec 2006 13:51:44 -0500, "M. Authement" <mautheme@kcc.com>
>> wrote:
>>
>>>I know this is not strictly and Excel question, but it does involve an
>>>application I am developing in Excel. I used mscal.ocx (version 11) on a
>>>userform and when I look at the references it is located in c:\Program
>>>Files\Microsoft Office\Office 11...no problem. Some of my users do not
>>>have
>>>this control, so when I Googled for more info, most of what I found says
>>>that it should be installed in C:\Windows\System32 (I do have version 8 of
>>>mscal.ocx located there). My question is this: does it matter where it is
>>>installed/registered? If users have it installed/registered in system32
>>>will they be able to open my .xla even though it is installed/registered
>>>in
>>>Office 11 on my computer? Would they still use regsvr32 mscal.ocx to
>>>register it no matter where it is located? Should I unregister/delete
>>>version 8 and move/re-register version 11 to the system32 folder? Thanks
>>>for your help (btw, I am using WinXP, Office 2003).
>>>
>>
>

Gord Dibben MS Excel MVP

Mickey Authement

12/19/2006 12:16:00 PM

0

I did, and I did see the message regarding the System32 folder. What I am
not sure of is the fact that for whatever reason, my computer has this
control located in the Program Files\Microsoft Office\Office 11 folder and
whether this reference will cause an error for those who have the control
registered in the System32 folder.

My guess is that it will not, as their system should (?) know where that
control is registered, but I have had enough 'false starts' with references
that I would like to know before asking them to try again. Thank you for
your patience...I've done quite a bit of VBA programming over the years, but
never dealt with anything outside of Excel's object model.

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:gt0eo2pf4r0084kmtkod9uvd34uk2blgfu@4ax.com...
> If you went to the site I posted and clicked the link to download the file
> you
> would have seen this message.........
>
> Copy the File to the Correct Folder
>
> After downloading the file, unzip it and copy the mscal.ocx file (and its
> associated help file if you require it) to the correct location on your
> computer. This location depends upon which version of Windows you are
> using:
>
> For Windows 95, 98 and ME this is C:\Windows\System
>
> For Windows NT, 2000, XP it is C:\Windows\System32
>
> Installations of Windows can vary so check for the correct location of the
> System or System32 folder before you proceed.
>
> Register the Control
>
> The final step is to tell the Windows Registry that you have installed the
> file.
> This ensures that your programs can find it. Click Start then Run and
> type:
> regsvr32 mscal.ocx and click OK:
>
>
> Gord
>
> On Mon, 18 Dec 2006 14:52:42 -0500, "M. Authement" <mautheme@kcc.com>
> wrote:
>
>>Thanks Gord. Any thoughts on my other questions about where the control
>>should be installed/registered and whether it matters if this location is
>>different from one machine to the next?
>>
>>
>>"Gord Dibben" <gorddibbATshawDOTca> wrote in message
>>news:3rqdo2tts2dounm5pl4dbbv6869ugnd0v2@4ax.com...
>>> mscal.ocx is installed only if the version of MS Office used contains
>>> Access.
>>>
>>> You can download mscal.ocx from here.
>>>
>>> http://www.fontstuff.com/vba/vb...
>>>
>>>
>>> Gord Dibben MS Excel MVP
>>>
>>> On Mon, 18 Dec 2006 13:51:44 -0500, "M. Authement" <mautheme@kcc.com>
>>> wrote:
>>>
>>>>I know this is not strictly and Excel question, but it does involve an
>>>>application I am developing in Excel. I used mscal.ocx (version 11) on
>>>>a
>>>>userform and when I look at the references it is located in c:\Program
>>>>Files\Microsoft Office\Office 11...no problem. Some of my users do not
>>>>have
>>>>this control, so when I Googled for more info, most of what I found says
>>>>that it should be installed in C:\Windows\System32 (I do have version 8
>>>>of
>>>>mscal.ocx located there). My question is this: does it matter where it
>>>>is
>>>>installed/registered? If users have it installed/registered in system32
>>>>will they be able to open my .xla even though it is installed/registered
>>>>in
>>>>Office 11 on my computer? Would they still use regsvr32 mscal.ocx to
>>>>register it no matter where it is located? Should I unregister/delete
>>>>version 8 and move/re-register version 11 to the system32 folder?
>>>>Thanks
>>>>for your help (btw, I am using WinXP, Office 2003).
>>>>
>>>
>>
>
> Gord Dibben MS Excel MVP