Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert excel 5.0 macro
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 -- Staes Ja ----------------------------------------------------------------------- Staes Jan's Profile: http://www.excelforum.com/member.php...fo&userid=1545 View this thread: http://www.excelforum.com/showthread.php?threadid=27075 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert excel 5.0 macro
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). -- Regards, Tom Ogilvy "Staes Jan" wrote in message ... 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 that the objects are not recognised and that some VBA statements have changed... Greetings, -- Staes Jan ------------------------------------------------------------------------ Staes Jan's Profile: http://www.excelforum.com/member.php...o&userid=15456 View this thread: http://www.excelforum.com/showthread...hreadid=270758 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lotus macro i need to convert to Excel | Excel Discussion (Misc queries) | |||
macro to convert excel to PDF | Excel Discussion (Misc queries) | |||
writing macro to convert excel to pdf | Excel Discussion (Misc queries) | |||
Convert Excel Functions to VBA Macro Function | Excel Programming | |||
Excel Macro To Convert XML File | Excel Programming |