KB179028 - XL97: Excel Object Is Not Closed After Running Macro

Article ID: 179028

Article Last Modified on 10/10/2006

SYMPTOMS

You open an Excel workbook object that has been inserted into a document in another program (for example, Microsoft Word). -and-
You run a Visual Basic for Applications macro that adds a name to the Names collection of the Excel workbook.

151261 OFF97: How to Obtain and Install MS Office 97 SR-2

To see an example of the problem, follow these steps:

Type the following code into the Visual Basic module sheet:

       Sub Test1()

          ActiveWorkbook.Names.Add Name:="Name1", RefersTo:="=Sheet1!a1"

       End Sub

On the File menu, click "Close and Return to Microsoft Excel."
On the File menu, click Save As. Type Test.xls in the File Name box, and then click OK.
On the File menu, click Exit.
Start Word.
On the Insert menu, click Object. Click the Create From File tab in the Object dialog box. Type Test.xls, and then click OK. Click Yes if a macro virus protection warning message appears.

The Excel workbook is inserted into the Word document.
Right-click the embedded Excel object, point to Worksheet Object on the shortcut menu, and then click Open.
In Excel, Point to Macro on the Tools menu, and then click Macros. Click Test1, and then click Run.
On the File menu, click "Close & Return to Document1."

The worksheet remains open in Excel.

Additional query words: vba cannot access accessing

Keywords: kbbug kbdtacode kbprogramming kbqfe KB179028