Excel 4.0 Macro Information

[DCSwearingen]

Where can I go to look at syntax for Excel 4.0 macros?

I have inherited some older spreadsheets and would like to convert to Excel 2003.

[davesexcel]

maybe just do a search in google to find that


this is a quote from J-Walk site

Will all of my Excel 5 VBA macros work perfectly with Excel 95?

Most of them will work fine -- with one exception. VBA macros that use 16-bit Windows API calls or calls to 16-bit DLLs will not work with Excel 95. These macros must be re-written to use the 32-bit Windows API or 32-bit DLLs.

Will all of my Excel 95 VBA macros work perfectly with Excel 5?

In most cases, yes. However, Excel 95 has a few enhancements to the language, so if you take advantage of any of these changes, your macro probably won't function properly with Excel 5. In addition, VBA macros that use 32-bit Windows API calls or 32-bit DLL calls will not work with Excel 5.

found here

http://j-walk.com/ss/excel/faqs/xl95faq1.htm