Hi All,

I've created a routine that drags live sales order info from our as400 server into an Excel spreadsheet.

I then have to select the Data > Export to Mappoint option when Excel loads.

I'd like to write a macro to automatically 'Export to Mappoint' when i open the spreadsheet.

Can anybody help? I'm more than happy to do the programming myself as i have a slight knowledge of VB but i just cant find enough references to get me going.

Thanks

Mark
???

Take a look at these examples -- Working With Excel and MapPoint - MP2K Magazine see if this is enough to get you started. Let us know!
Eric

Thanks for the help eric, definitely on the right track now. Only problem is i'm having trouble getting the example code to work.

Set oApp = CreateObject("MapPoint.Application.NA.11")
oApp.Visible = True

I'm using version 13 so i tried substituting the "NA.11" part with NA.13... i got i slightly different error but this appeared to help...

the problem is, i'm using the Europe version not the American version and i'm guessing the "NA." is a reference to North America or something like that.

I've tried substituting the NA. for E. and EU. but no joy, any ideas?

Thanks again.

Actually just try this

Code:

 
Set oApp = CreateObject("MapPoint.Application")

That should just load up whatever version or flavor of MapPoint is installed on your machine. Where the .NA and the version number (e.g. .11) can help is when you have different MapPoint's installed and you want to specify which one to load. Good question!

Eric