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...
This results in the URL being updated to: http://[my redirect URI]?code=XXXXXXXXXXXXXXXXXXXXXXXXX
Set oIExplorer = New InternetExplorer
.Visible = True
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.