Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Backwards compatibility with Excel 2003 Calendar Control
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Backwards compatibility with Excel 2003 Calendar Control
Tom,
I am not sure exactly what you are asking, but there is an embedded calendar control object in excel. (InsertObjectCalendar 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Backwards compatibility with Excel 2003 Calendar Control
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. (InsertObjectCalendar 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Backwards compatibility with Excel 2003 Calendar Control
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" wrote in message ... 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. (InsertObjectCalendar 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting backwards compatibility question | Excel Worksheet Functions | |||
Backwards Compatibility with Excel 2002 | Excel Discussion (Misc queries) | |||
Excel 2007 backwards compatibility - nesting functions | Excel Worksheet Functions | |||
backwards compatibility for Excel 2007 | Excel Discussion (Misc queries) | |||
Calendar Control in Excel 2000 can't display date in Excel 2003? | Excel Discussion (Misc queries) |