XL97: VBA Macro Behavior Is Different from Excel 5.0 or 7.0 (162721)

SUMMARY

When you run a Visual Basic for Applications macro in Microsoft Excel 97, the way the macro behaves may be different from the way it behaves in earlier versions of Microsoft Excel. This may be true for any of the following reasons:

The architecture of Microsoft Excel 97 is somewhat different from the architecture that is used in earlier versions of Microsoft Excel. Some elements (for example, menu bars and toolbars) are greatly enhanced in Microsoft Excel 97. As a result, Visual Basic code that interacts with these elements may work differently.
Microsoft Excel 97 corrects some problems that are present in earlier versions of Microsoft Excel. As a result, Visual Basic code that works in earlier versions of Microsoft Excel may work differently in Microsoft Excel 97.
Because all of the Microsoft Office programs include Microsoft Visual Basic for Applications, the Visual Basic environment in Microsoft Excel includes changes that accommodate the new programs and provide consistent behavior in all programs. As a result, code that uses OLE Automation or other cross-product functionality may work differently in Microsoft Excel 97.

Microsoft realizes the importance of minimizing the amount of effort that is required to use macros in Microsoft Excel 97. Microsoft Excel 97 is designed to be compatible with earlier versions of Microsoft Excel; however, in some cases, it may be necessary to modify your code so that it works in Microsoft Excel 97.

MORE INFORMATION

Modifying your code so that it works with Microsoft Excel 97 usually requires making only a few minor changes. The following is a list of articles in the Microsoft Knowledge Base that address compatibility issues in Microsoft Excel 97. Wherever possible, the articles contain the information you need to modify Visual Basic macros so that they function in both Microsoft Excel 97 and in earlier versions of Microsoft Excel.

143452 XL97: Excel Hangs When You Programmatically Save a Workbook

143453 XL: Named Arguments Are Not Supported with DAO

143458 XL97: Cannot Move or Copy Sheet After Last Sheet

143460 XL97: Overflow Error Occurs When Using Err Object

143461 XL97: CreateObject and GetObject Work Differently

154873 XL: Error When You Concatenate String and Numeric Values

156879 OFF97: Visual Basic Modules Cannot Be Hidden or Protected

156880 XL97: Using the MenuBars Method in Microsoft Excel 97

157027 XL97: Attached Toolbar Is Not Saved in 5.0/95 File Format

157103 XL97: Macro Stops Running When its Workbook is Closed

157107 XL97: "Type Mismatch" Comparing String Variable to Boolean

157108 XL97: Options not Available in Macro Options Dialog Box

157113 XL97: "Invalid Use of Null" Error Setting OnRepeat Method

157124 XL97: Styles("X").Parent Different Than in Earlier Versions of Excel

157203 XL97: Cannot Add Macros to the Tools Menu

157308 XL97: Calling RunAutoMacros Method More than Once Fails

157351 XL97: Compile Error Passing ParamArray

157412 XL97: Select Method May Select More Cells Than Expected

157436 XL97: DAO 3.0 CopyFromRecordSet Method Not Compatible with Excel 97

157471 XL97: Run-Time Error Using CreateObject With DAO.DBEngine

157553 OFF97: Dialog Boxes and UserForms Use Tahoma Font

157754 XL97: Problems When Disabling/Enabling Menus

157755 XL97: Using "Checked", "Gray", and "Unchecked" in Macros

158066 XL97: Reference to DAO 3.0 Changes to DAO 3.5 When File Opened

158072 XL97: Menu Added in Wrong Position on Menu Bar

158080 XL97: Cannot Paste Array Formula in its Original Cell

158222 XL97: ParamArrays are Always Zero-Based

158353 XL97: Error When Invalid Characters in Drawing Object Name

158355 XL97: ParamArray Must be Declared as an Array of Variant

158360 XL97: PasteSpecial Method Activates Target Sheet

158434 XL97: Cannot Make Changes to Some Shortcut Menus

158472 XL97: No Automatic Type Coercion Between Variable Types

158550 XL97: Problems Disabling and Enabling Shortcut Menus

158632 XL97: Limitations for Naming Visual Basic Modules

158638 XL97: ApplyNames Method May Cause Invalid Page Fault

158711 XL97: Cannot Edit Text Box with Unlocked Text

158746 XL97: Error When Passing an Array Value Between Macros

158801 XL97: Text is Truncated in a Text Box with Rounded Corners

158895 XL97: Invalid Page Fault After Closing Last Open Workbook

158905 XL97: "Bad DLL Calling Convention" When Running a Macro

158997 XL97: Error When Variable Refers to Deleted or Moved Sheet

159465 XL97: "Module not Found" Error Opening Workbook

159622 XL97: Cannot Change Value for Form Control on Worksheet

159794 XL97: Cannot Programmatically Close Referenced Workbook

159845 XL97: Parentheses Around Object May Dereference the Object

159861 XL97: Setting Window Caption Changes Caption for Active Window

159877 XL97: Crash Saving Workbook If Module Name Contains Equal Sign

159914 XL97: Bitmap Image Shrinks When Pasted on a Toolbar Button

159915 XL97: How to Delete Cells with a For Each...Next Loop

159922 XL97: Using Quit Method May Cause Illegal Operation

159938 XL97: Structure and Windows Arguments of Protect Method

159944 XL97: Range.PasteSpecial Changes Selection

159947 XL97: Illegal Operation Unhiding a Row with a Macro

159958 XL97: Unexpected Results Paste Linking Noncontiguous Range

159960 XL: Drawing Objects Behave Differently when Clicked

159964 XL97: Pointer is an Hourglass When You Display a Message Box

159966 XL97: Redraw Problem Changing Visibility of Object on Dialog Box

160032 XL97: Invalid Page Fault Saving a Workbook or Add-In

160058 XL97: Error Changing Order of Option Buttons on a Dialog Sheet

160085 XL97: Page Fault Accessing Demand-Loaded Add-in

160462 XL97: Auto_Close Macros Run When You Use Application.Quit

160520 XL97: Error Adding or Deleting a Menu Command in a Macro

163718 XL97: Page Setup Command Does Not Exist in Modules

164500 XL97: Help Argument for MsgBox Function Behaves Differently

164810 XL97: Run-Time Error Using ShowDependents Method

165103 XL97: Value Returned by VarType for Omitted Arguments Differs

165866 XL: How to Use File DSNs and DSN-less Connections

166101 XL97: Visible Property Does Not Apply to All CommandBars

167178 XL97: Some Properties and Methods Are Missing in Object Browser

168364 XL97: Charts.Delete Command in Macro May Delete Worksheets

168436 XL97: Can't Tile Windows with Macro If a Window Is Minimized

168754 XL97: Error Applying Comment When Worksheets Are Grouped

167277 XL97: Referenced Workbooks and Add-Ins Are Automatically Opened