Need VBA subroutine for MsAccess (2002, 2003) to query United Parcel Service for rates via the UPS api.
I have already built a working (but crude) one in asp.net, will be happy to send code. I have no idea where to start in VBA.
## Deliverables
Just need the subroutine with 1 form, I will plug it into my existing application to supply the data that needs to be sent to the UPS api.
1 - I supply subroutine (from existing form)? with destination, weight, value
2 - UPS returns XML with available ship methods & rates
3 - open Form with? option group from the XML response, will then return 1 selected method & rate
I will then load this in my existing application
Am pretty good with? vba & access, just need some help !!
Will have a few more things like this also.