Hi Ladies and Gents,
I've put together some code to pull/push data from MYOB (a commonly used accounting program here in Australia) via APIs. It all works beautifully with the locally stored company file, but i'm having some issues getting at the data stored in the cloud version.
The following part of my code works...
Code:
Set oIExplorer = New InternetExplorer
With oIExplorer
.Navigate CreateAuthRequest()
.Visible = True
End With
This results in the URL being updated to: http://[my redirect URI]?code=XXXXXXXXXXXXXXXXXXXXXXXXX
I've had a crack at:
1. Using oIExplorer.LocationURL to get the whole string (which gives me the boolean response True); and
2. oIExplorer.Document.getElementbyid("code").Value to get just the code value (which gives me an "Object Required" error).
Not sure where to go with this next. Any help much appreciated.
Mitch