PDA

View Full Version : VBA call for Exporting contents of a radius to a new, named Excel workbook



tonyk999
05-07-2009, 12:42 PM
I am trying to figure out how tp script a VBA call for Exporting contents of a radius to a new, named Excel workbook. Any suggestions?

right after this line:

objMap.Shapes.AddShape geoShapeRadius, objLoc, nRadius, nRadius

I want VBA to tell MP to export the data within the radius to a new wbk

Thanks

Tony

Mattys Consulting
05-07-2009, 03:00 PM
Hi Tony,

There isn't any such command, you'll have to automate Excel by code

Mike Mattys