does my excel form with vba made for 2003 work in the 2010 version?

**impartrudie** · 09-23-2011, 02:47 AM

Hi,
I,ve made a form in excel 2003 but now have to migrate it to excel 2010.
How can I be sure that it will work properly?
When I open it in 2010, it works fine, but when my collegue opens it, he get's errormessages.
Gratefull for all help!
Regards, Trudie

**snb** · 09-23-2011, 03:59 AM

What messages ?
In which VBA-lines ?

Grateful for all necessary, detailed information !

**royUK** · 09-23-2011, 04:54 AM

Has your colleague enable macros?

**impartrudie** · 09-23-2011, 04:56 AM

when opening up the form, there's an error right away.
My guess it's about a missing addin for the calendarform - not sure how to solve this.
I'll attach the whole workbook here, it would be very nice if you could help me out

regards,
Trudie

**snb** · 09-23-2011, 05:49 AM

I think your guess is right.

You protected the VBA-code too rigorously.

**impartrudie** · 09-23-2011, 06:16 AM

Can you please tell me what to do?
how can I make it a way that both excel 2003 and excel 2010 can run this file?

regards,Trudie

**snb** · 09-23-2011, 06:23 AM

Send the other user the mscal.ocx file that's on your system ( in the directory where Office has been installed) and let that user put the file into his/her office installation directory.

**romperstomper** · 09-23-2011, 06:35 AM

The Calendar control does not come with Office 2010, so perhaps your co-worker does not have it available. You also have a reference set to the RefEdit control, which can be problematic as it's not always in the same location on different machines. You should be able to simply uncheck the reference for that though.

**royUK** · 09-23-2011, 06:46 AM

I would change the Calendar Control to a non-ActiveX control

**impartrudie** · 09-23-2011, 07:57 AM

hi its no option to send the mscal.ocx to all the receivers, in order to install it on their machines.
Therefor i rather will try the 'non active x controll' if this is something that does not require extras to be innstalled on each machine the file is to be used.
Are you sure that the file is still useable with excel 2003 then (still compatilble?) and what kind of script can you recommend me?
regards,
Trudie

**royUK** · 09-23-2011, 08:05 AM

Have a look at the examples that I posted a link to

**impartrudie** · 09-23-2011, 08:20 AM

thanks, i'll give it a try this weekend

(no chance of getting boared)
regards,
Trudie

**snb** · 09-23-2011, 08:56 AM

If you have access to a webserver you can place the ocx-file on the webserver and build a small macro that retrieves the files and puts it into the correct folder of every user's system. (you will be distributing you userform also, isn't it ?).

does my excel form with vba made for 2003 work in the 2010 version?

LinkBack

Thread Tools

Rate This Thread

Display

does my excel form with vba made for 2003 work in the 2010 version?

Re: does my excel form with vba made for 2003 work in the 2010 version?

Re: does my excel form with vba made for 2003 work in the 2010 version?

Re: does my excel form with vba made for 2003 work in the 2010 version?

Re: does my excel form with vba made for 2003 work in the 2010 version?

Re: does my excel form with vba made for 2003 work in the 2010 version?

Re: does my excel form with vba made for 2003 work in the 2010 version?

Re: does my excel form with vba made for 2003 work in the 2010 version?

Re: does my excel form with vba made for 2003 work in the 2010 version?

Re: does my excel form with vba made for 2003 work in the 2010 version?

Re: does my excel form with vba made for 2003 work in the 2010 version?

Re: does my excel form with vba made for 2003 work in the 2010 version?

Re: does my excel form with vba made for 2003 work in the 2010 version?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions