Microsoft KB Archive/832117

Knowledge Base

The SmartTags Count property is not updated when a Smart Document solution is detached

Article ID: 832117

Article Last Modified on 2/10/2004

---

APPLIES TO

• Microsoft Office Excel 2003

---

SYMPTOMS

If you detach a Smart Document solution from a Microsoft Office Excel 2003 workbook, and then you view the SmartTag count for the workbook, the value that the Count property returns is not zero as expected. The value that the Count property returns is the same value that the Count property returned before you detached the Smart Document solution.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section of this article.

MORE INFORMATION

Steps to reproduce the problem

Note The following steps use information and files that are installed when you install the Microsoft Office 2003 Smart Document Software Development Kit (SDK). To obtain the SDK, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyId=24A557F7-EB06-4A2C-8F6C-2767B174126F

1. Add the registry key that disables the manifest security check:
   1. Locate and then double-click the DisableManifestSecurityCheck.reg file that Office 2003 Smart Document SDK Setup installed. This file is located in the C:\Program Files\Microsoft Office 2003 Developer Resources\Microsoft Office 2003 Smart Document SDK\Samples\SimpleSampleVB6 folder.
      
      The Registry Editor dialog box appears.
   2. Click Yes to add the registry key. In the confirmation message box, click OK.
2. Start Office Excel 2003.
3. On the File menu, click Open, and then locate the folder where the Office 2003 Smart Document SDK is installed. By default, the SDK is installed in the C:\Program Files\Microsoft Office 2003 Developer Resources\Microsoft Office 2003\Smart Document SDK folder.
4. Locate and then click the SimpleSample.xls file. This file is located in the Smart Document SDK\Samples\SimpleSampleVB6 folder. Click Open.
5. On the Data menu, click XML, and then click XML Expansion Packs.
6. Click Add.
   
   The Install XML Expansion Pack dialog box appears.
7. In the SimpleSampleVB6 folder, click Manifest.xml.
   
   A dialog box appears that prompts you to re-enable XML Expansion Pack security.
   
   Click No.
8. On the XML Expansion Pack tab, click to select the newly installed XML Expansion Pack, and then click Attach.
9. Click OK to close the dialog box.
   
   If the Document Actions task pane does not appear, close the SimpleSampleVB6.xls file, and then reopen the file. When the file is open, the Document Actions task pane appears.
10. On the Tools menu, click Macro, and then click Visual Basic Editor.
11. On the View menu in the Visual Basic Editor, click Immediate Window.

12. In the Immediate window, type the following code, and then press ENTER.

    ?activesheet.smarttags.count

    
    The value that the Count property returns is 19.

13. Close the Visual Basic Editor, and then return to Microsoft Excel.
14. In the Document Actions pane, click Detach XML Expansion Pack.
15. When you receive the following prompt, click Yes:

    Are you sure you want to permanently detach the XML Expansion Pack?

16. Repeat steps 10 through 12.
    
    The value that the Count property returns is not zero, as expected. The value is still 19.

Keywords: kbpending kbofficesmartdoc kbbug KB832117

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.