Using Power Automate to Run Excel VBA and Connect to a 32 bit Datasource

This was originally posted on Substack http://xcode.Substack.com Download files with code and database are included below the video Technical Specs: Sage 50 Accounting Database (32 bit Pervasive SQL) 32 bit ODBC Connector Office 365 (32 bit) Microsoft Access Database (linked to Sage 50 via ODBC) to manage ECommerce Product Data Microsoft Excel VBA (macro file […]

Continue reading

How to use Power Automate Desktop to Connect to an API, Process JSON, and Create and Post JSON

This tutorial is based on a client project. Technologies/Platforms Power Automate Desktop Orderspace.com (and API) Postman.com The screen shots & notes below accompany this video Video Step by step taking you through using Power Automate Desktop to: POST OAuth2 Client ID and Client Secret to the Orderspace identity server Retrieve an authentication token to be used for calls to the API GET (retrieve) orders, in […]

Continue reading