Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default MSCAL.ocx - CITRIX Metaframe XP

Hi Peoples,

I'm having some problems with the mscal.ocx (Calendar Control Version 10.0)
and CITRIX clients.

THe problem is that I have the Calendar control on numerous forms where the
users is prompted to select a date for a report output.

The organisation has a standard SOE, however, with the CITRIX clients they
are encountering a runtime error as the reference to the control is to an
older version. From the information that I have been able to find the the KB
is that version 10.0 is not backward compitable with older versions of the
control.

All citrix clients have Office XP installed, however the calendar control
version is 8.0. I thought that this was a bit odd as the control v10.0 ships
with XP?

I have tried unregistering the control deleting the old file, saving the
correct (v10.0) file and re-registering the control via regsvr32. We have
tried registering it from both the [C:\WinNT\System32\] and the [C:\Program
Files\Microsoft Office\Office10] directories, with no luck. What I have
noticed is that on the Standard XP Pro machines, the control is listed (in
the reference list) as "Calendar Control Version 10.0" where when you
register it from the Office10 directory it lists as "Microsoft Calendar
Control Version 10.0". I'm not sure if tis means anything (by the name
change) but it won't allow the control to load.

Problems that are being encountered a

The form control won't load, at all.

The form loads, and allows the user to press the date grid, but no event is
called (where there is a on_change event)

A run-time error crashes excel all together. (On module MSCAL.ocx) I'm sorry
I don't have the error number/address, I'll post it back tomorrow.

I guess what I'm asking is whether anyone else has had this sort of a
problem, and if so what options are there to get around it. Also, what is
the correct procedure to register the control via regsvr 32. I have been
told that in w2K you can register the control from the system32 directory,
without having the control in that directory, or is it BP to register it
from the Office10 dir, or register the control with the full path from the
system32 dir (ie. regsvr32 "C:\Program Files\Microsoft
Office\Office10\MSCAL.ocx"

Thanks in advance.

Paul M.


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default MSCAL.ocx - CITRIX Metaframe XP

After exhaustive testing and resolving to that the M$
Calendar Control needs a few more versions under it's
belt before M$ sort out the current issues. I have found
with thands to Phil From Dallsa, TX a coded Calendar for
use in an excel form. Doen't require the dredded
MSCAL.ocx and looks good to. See post on www.ozgrid.com

http://www.ozgrid.com/forum/viewthread.php?tid=891

to download the example file.

Paul M.


-----Original Message-----
Hi Peoples,

I'm having some problems with the mscal.ocx (Calendar

Control Version 10.0)
and CITRIX clients.

THe problem is that I have the Calendar control on

numerous forms where the
users is prompted to select a date for a report output.

The organisation has a standard SOE, however, with the

CITRIX clients they
are encountering a runtime error as the reference to the

control is to an
older version. From the information that I have been

able to find the the KB
is that version 10.0 is not backward compitable with

older versions of the
control.

All citrix clients have Office XP installed, however the

calendar control
version is 8.0. I thought that this was a bit odd as the

control v10.0 ships
with XP?

I have tried unregistering the control deleting the old

file, saving the
correct (v10.0) file and re-registering the control via

regsvr32. We have
tried registering it from both the [C:\WinNT\System32\]

and the [C:\Program
Files\Microsoft Office\Office10] directories, with no

luck. What I have
noticed is that on the Standard XP Pro machines, the

control is listed (in
the reference list) as "Calendar Control Version 10.0"

where when you
register it from the Office10 directory it lists

as "Microsoft Calendar
Control Version 10.0". I'm not sure if tis means

anything (by the name
change) but it won't allow the control to load.

Problems that are being encountered a

The form control won't load, at all.

The form loads, and allows the user to press the date

grid, but no event is
called (where there is a on_change event)

A run-time error crashes excel all together. (On module

MSCAL.ocx) I'm sorry
I don't have the error number/address, I'll post it back

tomorrow.

I guess what I'm asking is whether anyone else has had

this sort of a
problem, and if so what options are there to get around

it. Also, what is
the correct procedure to register the control via regsvr

32. I have been
told that in w2K you can register the control from the

system32 directory,
without having the control in that directory, or is it

BP to register it
from the Office10 dir, or register the control with the

full path from the
system32 dir (ie. regsvr32 "C:\Program Files\Microsoft
Office\Office10\MSCAL.ocx"

Thanks in advance.

Paul M.


.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default MSCAL.ocx - CITRIX Metaframe XP


The book mentioned just uses the standard office calender control
distributed / installed with office (as an option under ms-access)

Works fine in Excel XP but completely crashed Excel 2003.

That was caused by the "poor" implement of getting it to load modeless
in xl97. Be very careful about the dragdrop statements and api stuff in
the book. They are all related to making the form modeless in Excel97
But the code is also (needlessly) run for newer versions.

When I disabled those lines and just loaded the form with vbmodeless
param I had no further probs.


form_activate
workbook_open
workbook_close


Can't test for Citrix though. :)

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Paul M" wrote:

After exhaustive testing and resolving to that the M$
Calendar Control needs a few more versions under it's
belt before M$ sort out the current issues. I have found
with thands to Phil From Dallsa, TX a coded Calendar for
use in an excel form. Doen't require the dredded
MSCAL.ocx and looks good to. See post on www.ozgrid.com

http://www.ozgrid.com/forum/viewthread.php?tid=891

to download the example file.

Paul M.


-----Original Message-----
Hi Peoples,

I'm having some problems with the mscal.ocx (Calendar

Control Version 10.0)
and CITRIX clients.

THe problem is that I have the Calendar control on

numerous forms where the
users is prompted to select a date for a report output.

The organisation has a standard SOE, however, with the

CITRIX clients they
are encountering a runtime error as the reference to the

control is to an
older version. From the information that I have been

able to find the the KB
is that version 10.0 is not backward compitable with

older versions of the
control.

All citrix clients have Office XP installed, however the

calendar control
version is 8.0. I thought that this was a bit odd as the

control v10.0 ships
with XP?

I have tried unregistering the control deleting the old

file, saving the
correct (v10.0) file and re-registering the control via

regsvr32. We have
tried registering it from both the [C:\WinNT\System32\]

and the [C:\Program
Files\Microsoft Office\Office10] directories, with no

luck. What I have
noticed is that on the Standard XP Pro machines, the

control is listed (in
the reference list) as "Calendar Control Version 10.0"

where when you
register it from the Office10 directory it lists

as "Microsoft Calendar
Control Version 10.0". I'm not sure if tis means

anything (by the name
change) but it won't allow the control to load.

Problems that are being encountered a

The form control won't load, at all.

The form loads, and allows the user to press the date

grid, but no event is
called (where there is a on_change event)

A run-time error crashes excel all together. (On module

MSCAL.ocx) I'm sorry
I don't have the error number/address, I'll post it back

tomorrow.

I guess what I'm asking is whether anyone else has had

this sort of a
problem, and if so what options are there to get around

it. Also, what is
the correct procedure to register the control via regsvr

32. I have been
told that in w2K you can register the control from the

system32 directory,
without having the control in that directory, or is it

BP to register it
from the Office10 dir, or register the control with the

full path from the
system32 dir (ie. regsvr32 "C:\Program Files\Microsoft
Office\Office10\MSCAL.ocx"

Thanks in advance.

Paul M.


.



Reply
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
MSCal.ocx and Office 2007 DRA Excel Discussion (Misc queries) 0 September 10th 07 01:28 AM
MSExcel cannot be opened on Citrix sujith suraweera Excel Discussion (Misc queries) 1 January 16th 07 10:26 AM
Moving Macro's to Citrix lk Excel Worksheet Functions 6 October 14th 06 12:07 AM
Add-in and Citrix James T Excel Discussion (Misc queries) 0 April 24th 06 08:55 AM
MSCAL.Calendar erickabrew Excel Discussion (Misc queries) 1 June 28th 05 03:36 PM


All times are GMT +1. The time now is 05:12 AM.

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"