Hello,
I need a vba code written that looks at a 'tracking' table in MS Access.
Based on the carrier name, send a API request to UPS,USPS or FEDEX for status
of tracking.
Hi. Great app writer for your projects. I have writen scraping, excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile
Hi, I already worked on same type of project with access vba to get status of FedEx, USPS, ups. We can use FedEx code via dll import method.
thanks
Mani
Hello, FedEx API to Access is little bit difficult. However I can achieve the task using TLB (same like DLL) reference which we generate from C#/vb.net
I have already done this task so i can finish this task in a day.
Idea is add reference "tlb" file in Access and get tracking details.
Thanks, Ram
I have worked with VBA and Access for over 13 years. I have spent the majority of that time scripting dynamic API calls.
If python is an option, the web requests can be run asynchronously. If not, then VBA can be used to retrieve the data.