[ Go to October 1997 Table of Contents ]|
It's definitely not easy to convert your macros from Office 95 to Office 97. In our WinMag benchmark macro tests, we finally gave up trying to convert our Word macro. The translation-from Word Basic to VBA-was so riddled with errors that it proved less difficult to create a new macro from scratch. Excel macro creation used to be easier, but Microsoft has tightened up its requirements here. Code in Excel 95 that was technically incorrect (setting an option that isn't available for the chart type we chose) was ignored in Excel 95; Excel 97 generates an error instead.