If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problem while Updating US MAP
Hi,
I am using Excel 2000. I have data for all US states. Using Map feature I am creating US MAP with data plotted. I do some reformating and it is perfect. Another thing that I am doing is changing the data. Thereafter, I need to refresh the Map through Macro. I used following Macro to refresh MAP: ActiveSheet.Shapes("Object 4").Select Selection.Verb Verb:=3 This works fine. My problem starts when I save and close the file and re-open. Then when I run the macro it gives me error: An error has occured while retrieving data from Microsoft Excel. Any help. Regards, Beetle --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|