Hi everyone,
I'm moving my project from 2010 to 2013 (no other option) and all is working fine but the frmCal, my guess is cause the MonthView Control is missing. Is there anything that replaces it?
Please advise.
JC
Printable View
Hi everyone,
I'm moving my project from 2010 to 2013 (no other option) and all is working fine but the frmCal, my guess is cause the MonthView Control is missing. Is there anything that replaces it?
Please advise.
JC
You should have the same control available in Excel 2013. However, the MSCOMCTL.ocx file version might be different, and hence would be throwing an automation error. One way would be to update your form with the latest control, OR (haven't tested that for 2013, but it did work when I had an issue with Excel 2007 service pack change), downgrade this particular ocx file in your computer by registering the older version of this file.
Hi vlc
Don't have Excel 2013 and don't know what the MonthView Control is. I suspect it's the old Calendar Control from pre Excel 2007. If so this link may be of help
Non ActiveX Calendar Control
I have been using a date picker that is able to work in both office 2007 and 2010 and I find it very handy.
In my home pc, Office 2010, english regional settings used everything is working great!
However I use this control in my work laptop that has Greek regional settings (in order to make other apps work) and office 2007.
The only problem is that the month name is not showing properly... see the pic below...
Attachment 1002
If I click on the month name and the drop down list appears with all months then they all show up properly and they are readable.
I know that I could just change my windows regional settings but this is not an option since other apps installed from my company IT dept will stop working.
Is there any way to make the specific control show the months always in English like in the pic below?
Attachment 1003
Sorry not to ask in a new thread but since there is a related thread already it seemed proper to post here!
Mr. Black'd
Mr Blackd, can you post a sample workbook with this control?
In addition, did you try the custom calendar control I've posted at http://www.excelfox.com/forum/f13/of...controls-1238/
Here you go... Attachment 1004Quote:
Originally Posted by Excel Fox
Note that I have found this online as an alternative to an older date picker form that was working only in office 2007.
And it does a great job but ... well I described the issue above %p
but in order to clarify more I add these two screenshots of the file I attach
one with the form as seen with greek regional settings
Attachment 1005
and one with the form as seen with english regional settings
Attachment 1006
I have already seen this form for the date here today but not in detail...Quote:
Originally Posted by Excel Fox
I will probably use it if I fail to find a solution to my issue. ;)
And thanks for your reply.