Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lotus macro i need to convert to Excel Sammy Excel Discussion (Misc queries) 4 April 28th 10 09:31 PM
macro to convert excel to PDF EricBB Excel Discussion (Misc queries) 2 March 18th 09 04:03 PM
writing macro to convert excel to pdf matt Excel Discussion (Misc queries) 5 February 23rd 07 12:50 AM
Convert Excel Functions to VBA Macro Function Simon Corner Excel Programming 3 April 2nd 04 11:58 AM
Excel Macro To Convert XML File John[_52_] Excel Programming 3 September 4th 03 05:34 PM


All times are GMT +1. The time now is 09:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"