Microsoft KB Archive/213411

= XL2000: Data Map Objects Limited to RefreshMap Command =

Article ID: 213411

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q213411





SUMMARY
In a Microsoft Visual Basic for Applications macro, the Data Map object is limited to a single command, RefreshMap. The RefreshMap command updates a Data Map object in a Microsoft Excel 2000 worksheet.



MORE INFORMATION
The following examples illustrate how you can use the RefreshMap command in a macro:

ActiveSheet.OLEObjects("Picture 1").Object.Refreshmap

- or -

ActiveSheet.OLEObjects("Object 1").Object.Refreshmap

In these examples, "Picture 1" and "Object 1" are the names of Data Map objects. To determine the name of a Data Map object, click the object once, and then look in the Name Box (below the File menu and to the left of the Formula Bar).

Additional query words: XL2000

Keywords: kbhowto kbinfo kbprogramming KB213411

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.