Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Macro backward compatibility from excel 2002 to excel 2000
I have read that in the excel help that "the Microsoft Excel 2002 file
format does not differ from the Microsoft Excel 2000 and Excel 97 file formats, but it does differ from earlier versions". Unfortunately I have received feedback that it doesn't seems to be a macro backward compatibility from Excel 2002 to Excel 2000. I have unsuccessfully tried to save an Excel 2002 workbook as a Excel 2002/excel 97 compatible format, and there is no Excel 2000 option in the "Save as type" rolldown menu. Is there any way to solve this problem or workaround it? Thanks for suggestions. Frank Krogh |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Macro backward compatibility from excel 2002 to excel 2000
Hi
always try to develop in the lowest version. There's no option to convert macros to a lower version. -- Regards Frank Kabel Frankfurt, Germany Frank Krogh wrote: I have read that in the excel help that "the Microsoft Excel 2002 file format does not differ from the Microsoft Excel 2000 and Excel 97 file formats, but it does differ from earlier versions". Unfortunately I have received feedback that it doesn't seems to be a macro backward compatibility from Excel 2002 to Excel 2000. I have unsuccessfully tried to save an Excel 2002 workbook as a Excel 2002/excel 97 compatible format, and there is no Excel 2000 option in the "Save as type" rolldown menu. Is there any way to solve this problem or workaround it? Thanks for suggestions. Frank Krogh |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Macro backward compatibility from excel 2002 to excel 2000
Hi Frank,
The file format is compatible from 2002 to 97, but if you use features that are Excel 200 or excel 2002 only they wont work in 97. VBA code is lcompatible except if you use Excel 2002/2000-only object model features or use VBA6 only features. (Excel 97 is VBA5) You may need to change the references (Tools References) If all else fails then export the modules and forms from Excel 2002 and import them into Excel 97. regards Charles ______________________ Decision Models FastExcel Version 2 now available. www.DecisionModels.com/FxlV2WhatsNew.htm "Frank Krogh" wrote in message ... I have read that in the excel help that "the Microsoft Excel 2002 file format does not differ from the Microsoft Excel 2000 and Excel 97 file formats, but it does differ from earlier versions". Unfortunately I have received feedback that it doesn't seems to be a macro backward compatibility from Excel 2002 to Excel 2000. I have unsuccessfully tried to save an Excel 2002 workbook as a Excel 2002/excel 97 compatible format, and there is no Excel 2000 option in the "Save as type" rolldown menu. Is there any way to solve this problem or workaround it? Thanks for suggestions. Frank Krogh |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Macro backward compatibility from excel 2002 to excel 2000
If you develop a macro to be used over multiple versions, the macro code has
to either take care to not use VBA not supported in earlier versions or to appropriately design the code so code for later versions is not in the same modules as code for earlier versions. In the latter case, you then choose which code to execute at run time. -- http://www.standards.com/; See Howard Kaikow's web site. "Frank Krogh" wrote in message ... I have read that in the excel help that "the Microsoft Excel 2002 file format does not differ from the Microsoft Excel 2000 and Excel 97 file formats, but it does differ from earlier versions". Unfortunately I have received feedback that it doesn't seems to be a macro backward compatibility from Excel 2002 to Excel 2000. I have unsuccessfully tried to save an Excel 2002 workbook as a Excel 2002/excel 97 compatible format, and there is no Excel 2000 option in the "Save as type" rolldown menu. Is there any way to solve this problem or workaround it? Thanks for suggestions. Frank Krogh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table in Excel 2007 & 2000 (backward compatibility problem) | Excel Discussion (Misc queries) | |||
Excel 2007 Color Backward-Compatibility Issue | Excel Discussion (Misc queries) | |||
Excel 2007 backward compatibility re colors | New Users to Excel | |||
Backward and Forward Compatibility | Excel Discussion (Misc queries) | |||
macro written in Excel 2000 not working in Excel 2002 | Excel Programming |