XL2000: Data Map Objects Limited to RefreshMap Command (213411)


The information in this article applies to:

  • Microsoft Excel 2000
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).
Modification Type:MinorLast Reviewed:10/11/2006
Keywords:kbhowto kbinfo kbProgramming KB213411
©2004 Microsoft Corporation. All rights reserved.