MSCAL.OCX and Excel 2010

[tone640]

I was originally getting an error because the calendar I was using in 2007 was not working in 2010, so I have added MSCAL.OCX to the SysWOW folder (for 64-bit Windows 7) and registered it. This solved the initial problem (of a Mid function not being recognised??), but the code is now giving an error on lines with 'Calendar1' - now it says 'Variable not assigned'.

After a fair bit of googling, I think I've reached a dead end - can anyone shed any light on this?

Thanks in advance.

[tone640]

Bump - anyone?

[JosephP]

did you add a calendar control to wherever you had one before?

[alansidman]

I think this link (3rd item) will explain what has happened.

[JosephP]

which link?

[alansidman]

Thanks JP. Having a senior moment.

http://www.fontstuff.com/index.html