Hi,

I am using excel to print invoices for my company and want to insert a small map from mappoint or autoroute for the delivery driver. I know a small amount of VB and was wondering if anyone knew how to write a macro in excel that could do this.

I have the customers postcode (uk) in excel and need a 3 inch square image covering aproximately 1 sq mile.

If anyone can help it would be much appreciated.
Thanks,

Jim

Chris Gebhardt wrote some simple examples, see the article section: "Using MapPoint from Word, Excel, and Access". There are many more examples, look at bit thoughout the site.

Eric

jimbob,

I've written a macro which will produce maps in excel.

If you want I can send you the VBA code and you can take it from there. My code uses lat/longs.

adam

To insert a map or image into excel is easy. The code in the link below is used for inserting images into word using VBA excel but just skip the word part and insert the image into excel instead and your problem is solved!

Insert Image to Word, Resize Image, Insert Borders using VBA Excel