Backwards compatibility with Excel 2003 Calendar Control

[Guest]

I have found that the back-end programming for the StartDay property on an
embedded calendar is not consistent between Excel 2000 and Excel 2003.

For instance, I had the startday on the calendar set to Sunday in 2000. When
I opened the worksheet in 2003 the startday was set to Monday.

When I changed the startday to Sunday in 2003, it was set as Saturday if I
opened it in 2000.

I have not been able to find any fixes on this, I simply had to create
separate worksheets for both versions.

As many of you know, this gets complicated for the end-users. Does anyone
have any better ideas? It will still be a bit before we can upgrade all of
our users to Office 2003.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...288f344&dg=microsoft.public.excel.programming

 

[Guest]

What is the embedded calendar?

 

[Guest]

Tom,
I am not sure exactly what you are asking, but there is an embedded
calendar control object in excel. (Insert>Object>Calendar Control x.x)

This inserts a calendar. If you right-click on the calendar and choose
properties, then you can edit which day is on the far left of the calendar.

The issue is that selecting sunday in 2000 returns a value of monday when
opened in 2003. I think of it like the following:

Office 2000 Office 2003
Sun = 0 Sun = 6
Mon = 1 Mon =0
Tue = 2 Tue = 1
Wed = 3 Wed = 2
Thu = 4 thu = 3
Fri = 5 fri = 4
Sat = 6 sat = 5

Since the values are different from 2000 to 2003, there is no way to get the
same results from a calendar in both 2000 and 2003.

I hope this helps.

 

[Guest]

I placed the Calendar Control 11 in a worksheet and it in the properties,
selected sunday for the "firstday" property. When I queried it in the VBE it
showed

? ActiveSheet.Calendar1.Firstday
7

If I do
Activesheet.Calendar1.Firstday = 0
it stays with Sunday

ActiveSheet.Calendar1.Firstday = 6
starts with Saturday

Activesheet.Calendar1.FirstDay = 1
it starts with Monday.

I was using xl2003, US English.

 

[Tom Ogilvy]

I finally got to a copy of xl2000 and use calendar control 9.0.

Activesheet.Calendar.Firstday

returned a 1 for the firstday being Sunday. 7 for a first day of Saturday.

xl2000 US English, Windows XP for both

So I agree with you that they are different.
xl 2003 starts with Monday (value 1)
xl2000 starts with Sunday (value 1)

for the systems I tested on.

Setting to 0 actually doesn't change anything, but it doesn't raise an
error.

--
Regards,
Tom Ogilvy

I placed the Calendar Control 11 in a worksheet and it in the properties,
selected sunday for the "firstday" property. When I queried it in the VBE it
showed

? ActiveSheet.Calendar1.Firstday
7

If I do
Activesheet.Calendar1.Firstday = 0
it stays with Sunday

ActiveSheet.Calendar1.Firstday = 6
starts with Saturday

Activesheet.Calendar1.FirstDay = 1
it starts with Monday.

I was using xl2003, US English.

http://www.microsoft.com/office/com...288f344&dg=microsoft.public.excel.programming