I am not sure is this is the correct section of the forum. If not please reply and let me know which section is more appropriate.
I am writing a VBA Excel app that takes formatted tables and automatically builds either territory or data maps based on information in the table. These could be just one or two maps or three hundred hence the automation...
I need to find out if it is possible to accomplish 1 of 2 things:
1) Order the quintiled counties data so I can predict the color of the shaded areas -- using color scheme 15 all of the time user cannot change it
2) Is it possible to save the legend and then copy map and legend to a Power Point presentation. Currently using objMap.CopyMap to copy to the clipboard.
Or easier maybe...Is there any way to save the map as a gif or jpg...like a screen shot? I am a little desparate here as I cannot find any resources for this.
I am fairly new to Map Point developmentso any and all advice is appreciated.
Thanks In Advance,
TBirdSimpleMuse![]()