XL97: Incorrect Workbook Saved from Visual Basic Editor

• Microsoft Excel 97 for Windows

SYMPTOMS

In Microsoft Excel, when you save a workbook from the Visual Basic Editor, the wrong workbook is saved. Specifically, Excel saves the active workbook from the main Excel window, instead of the one you wanted to save from the Visual Basic Editor.

CAUSE

This problem occurs when the following conditions are true:

• You have multiple workbooks open.
  
  -and-



• You start the Visual Basic Editor and select a sheet that is not in the currently active workbook by clicking the sheet name in the Project Explorer window.
  
  -and-



• You save the workbook more than once while in Visual Basic Editor.

WORKAROUND

To work around this problem, select VBAProject (<Bookname>) in the Project Explorer window, and then click Save <Bookname> on the File menu, where <Bookname> is the name of the workbook to be saved.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 97 for Windows.

MORE INFORMATION

This problem occurs because Excel always assumes you want to save the active workbook, unless you specifically select another workbook in the Project Explorer each time before saving. After each save, Excel again selects the active workbook in the Project Explorer.

To determine the active workbook, while in the Visual Basic Editor, click "Close and Return to Microsoft Excel" on the File menu. In the main Excel Window, notice which workbook is currently displayed.

REFERENCES

For more information about saving files, click Contents And Index on the Help menu, click the Index tab in Microsoft Help, type the following text

saving, files

Additional query words: XL97 vbe

Keywords : kbdta xlloadsave xlvbainfo
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb