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 development so any and all advice is appreciated.

Thanks In Advance,

TBirdSimpleMuse

Hi,

1 Sorry I don't know.
2 You can use SaveAs method. It save the map as jpg.

Thanks for the help Wilfried. I am using the following code:

If OutPath = "" Then OutPath = DataPath
If InStr(strSheet, OutPath) = 0 Then
objMap.SaveAs OutPath & "\" & strSheet & ".jpg"
Else
objMap.SaveAs strSheet & ".jpg"
End If


the only problem is that the file is now saving with following extension:

A46223D.jpg.ptm

I guess i just need to work with the PTM format. Thanks tho.

TBird

Hi,

No you can save it as HTML. Then a HTML page is generated and also a JPG. The HTML has then a link to the JPG, but you can delete the HTML and use the picture.