Excel 2007 - 2010 VBA to interact / automate a commercial compiled database - with no back door

[warbucks]

Gday all

Transportation sector - outsourced cell phone tracking app for our daily loads from across the US

First time VBA user

1. Get all trucks (load no's) from Tuesday to Saturday - Done - simple export from an Access database maketable query I created to excel
2. Google mapping API - run miles from last - current - destination - Done
3. Open the tracking web site - login / password, navigate to proper form (3rd page), to begin tracking loads - done

4. Loop through the excel spreadsheet (200+ records) - not quite done yet ...........

Now to my question

Once I loop through the 200 tucks to determine locations, miles run - miles to go , and bring this info back to Excel to run the miles via goole maps, how does one interact with a commercial compiled database written 20 years ago, with no backdoor supplied by the author.

The database is on a cloud, I can automate logging in etc, but not sure how to choose the fields with VBA

Can VBA determine field names etc in this instance? or would I have to go by the fileds onscreen positioning etc? (nightmare on different size / resolution screens I imagine)

In other words I want to take current location, miles to go. Open the cloud database, input the load No, to open the order, hit add field button and input the location / miles into a comment section, then save and exit the order - on to the next order No

regards

Will

 

[warbucks]

Shakes head.....
this code will get the cursor screen position, how to chain it with VBA for auto input of the Order numbers to open for input

Declare Function GetCursorPos Lib "user32" (lpPoint As POINTAPI) As Long
' Create custom variable that holds two integers
Type POINTAPI
Xcoord As Long
Ycoord As Long
End Type

Sub GetCursorPosDemo()
Dim llCoord As POINTAPI
' Get the cursor positions
GetCursorPos llCoord
' Display the cursor position coordinates
MsgBox "X Position: " & llCoord.Xcoord & vbNewLine & "Y Position: " & llCoord.Ycoord
End Sub

 

[warbucks]

Excel forum, and 2 replies from myself....lol. Cmon folks..........say something, go away, a code snippet, anything............shakes head again