Excel Visual Basic managing coordinate tuple type

Question

I'm attempting to automate an external program that provides API using excel visual basic macros. I am attempting to call a function using ProgAPI, an object I made to interface with the API.

ProgAPI.getcoordinate(map1, point1)

That would provide me with a coordinate in the form (x, y), which I've been informed is a tuple. When I do, I am unable to put the coordinate into a variable.

sub getcoor
dim coor as double
coor = ProgAPI.getcoordinate(map1, point1)
end sub

I'm assuming because (x,y) has 2 entries. Does anyone know how to store this tuple in visual basic?

Answer 1

A tuple can be saved as an array of two values. To store the coordinates as an array, you can change the code as follows:

Sub GetCoor()
    Dim coor() As Double
    coor = ProgAPI.getcoordinate(map1, point1)
End Sub

The coor variable is specified as a Double-type array in this code. The two values in the tuple will be saved in the array when you assign the outcome of ProgAPI.getcoordinate(map1, point1) to coor. Then, each value can be accessed by its index, such as coor(0) for the first value and coor(1) for the second.