mappoint 2002 euro VBA

[SQLScholar]

hey all,

I hope you can help me.

I am trying to make an automated program using excels VBA and the mappoint linkage.

What the idea is, that it will ask for a Uk postcode - once given it will go onto mappoint and bring back into a spreadsheet, how close each of 118 other postcodes are.

This shouldnt be too difficult in my mind - i have a list of all the postcodes in excel and i should be able to get it to lookup off the excel spreadsheet.

But currently i have tried to just program it with 2 places, yet i still cant get it to return a value. Errors upon errors upon errors.

I would post the code, but its so confusing with all the things i have tried i am actually going to start again because i dont know where i am.

Any help much appreciated.

Regards

Dan

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!

 

[SQLScholar]

some of the code i have now done is

Sub Macro2()
'
' Macro2 Macro
' Macro recorded 06/10/2003 by Daniel Fountain
'
Dim MPApp As New MapPoint.Application
Set MPApp = New MapPoint.Application
MPApp.Visible = True
MPApp.UserControl = True
Dim objMap As MapPoint.Map
Dim objLoc1 As MapPoint.Location
Dim objLoc2 As MapPoint.Location
Dim objCenter As MapPoint.Location

objLoc1 = objMap.FindAddressResults(, , , , IP21ET)


'
End Sub

yet i keep getting an error saying object or block not defined (and i tried the pcode with a space and with speach marks)

any ideas?


----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!