Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: Data Map Objects Limited to RefreshMap Command

XL2000: Data Map Objects Limited to RefreshMap Command

View products that this article applies to.

This article was previously published under Q213411

↑ Back to the top

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.

↑ Back to the top

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).

↑ Back to the top

Keywords: KB213411, kbprogramming, kbinfo, kbhowto

↑ Back to the top

Article Info
Article ID : 213411
Revision : 6
Created on : 10/11/2006
Published on : 10/11/2006
Exists online : False
Views : 388