Convert excel 5.0 macro

S

Staes Jan

Dear all,

I have a quiet extensive program that has been written for excel 5.0.

Is there a way to convert it to a excel 2000 version. I understand tha
the objects are not recognised and that some VBA statements hav
changed...

Greetings
 
T

Tom Ogilvy

Best way is to open it in Excel 2000 and compile it. Research and correct
errors as they occur. Errors should be few, however.

Excel 97 and later use Userforms and a different menu object, but support
those used in Excel 5.0. You shouldn't have to convert those unless you
want to. (menus built with the menu editor can not be permanently altered
except in xl5/95 using the menu editor - there is no menu editor in Excel
2000).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba in excel 2007 5
How to convert text file into excel using macro vba 2
Second run of macro hangs on .show of application.filedialog object! 3
convert Microsoft Excel 5.0/95 to ms excel 2003 6
Excel 2002 Errors 1
Macro to Consolidate Data from Various Excel Files 1
Convert to Excel Macro 3
Convert to Excel Macro 2

Top