Backwards compatibility with Excel 2003 Calendar Control

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/comm...el.programming

What is the embedded calendar?

--
Regards,
Tom Ogilvy


"Whiskey Tango Foxtrot" wrote:

> 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/comm...el.programming

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.


"Tom Ogilvy" wrote:

> What is the embedded calendar?
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Whiskey Tango Foxtrot" wrote:
>
> > 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/comm...el.programming

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.

--
Regards,
Tom Ogilvy


"Whiskey Tango Foxtrot" wrote:

> 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.
>
>
> "Tom Ogilvy" wrote:
>
> > What is the embedded calendar?
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "Whiskey Tango Foxtrot" wrote:
> >
> > > 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/comm...el.programming

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

"Tom Ogilvy" <TomOgilvy@discussions.microsoft.com> wrote in message
news:325E5799-CB1E-4904-8149-91DB22F7084F@microsoft.com...
> 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.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Whiskey Tango Foxtrot" wrote:
>
> > 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.
> >
> >
> > "Tom Ogilvy" wrote:
> >
> > > What is the embedded calendar?
> > >
> > > --
> > > Regards,
> > > Tom Ogilvy
> > >
> > >
> > > "Whiskey Tango Foxtrot" wrote:
> > >
> > > > 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/comm...el.programming