Route using lat/long in excel

Microsoft MapPoint

I have had a devil of a job finding the answer to this question which
probably has a simple answer.
I have some code that calculates a series of a to b routes using
postcodes. It works just fine.
I now need to calculate the same but for this new list I only have
latlongs.
I can't work how to change my code to use coordinates. Help Please.
Code below

Private Sub CommandButton1_Click()
Dim Row As Integer

'Sets results to miles
Set objApp = New MapPoint.Application

Set oApp = CreateObject("MapPoint.Application.eu.11")
oApp.Visible = False
ScreenUpdating = False
oApp.UserControl = True


Set objMap = oApp.NewMap
Set objRoute = objMap.ActiveRoute


Row = 2
While Worksheets("Sheet1").Cells(Row, 1) <> ""

szZip = Worksheets("Sheet1").Cells(Row, 1)
szZip1 = Worksheets("Sheet1").Cells(Row, 2)
objRoute.Waypoints.Add objMap.FindResults(szZip).Item(1)
objRoute.Waypoints.Add objMap.FindResults(szZip1).Item(1)
objApp.Units = geoMiles

'THIS ITEM SETS SHORTEST ROUTE
objRoute.Waypoints.Item(1).SegmentPreferences =
geoSegmentShortest

objRoute.Calculate


Worksheets("Sheet1").Cells(Row, 3) = objRoute.Distance
objRoute.Clear
Row = Row + 1
Wend
'Get the name of the app
MsgBox "Application name: " + objApp.Name

'Quit the application
'objApp.Quit

oApp.Quit