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

How to use Google App Scripts to send HTML emails from Google Sheets with Airtable Data

I don’t demonstrate pulling data from Airtable in this video or code example. If you’d like that, check out my previous article on my client’s Airtable Reporting Dashboard using Google App Scripts, BigQuery, and Google Data Studio. The code to pull Airtable data is there. However, this is a Goals vs Actuals Dashboard in use […]

Continue reading

Airtable Reporting System using Google Apps Script, BigQuery, and Google Data Studio with source code

Airtable Report Dashboard Using Google Apps Script, Google Big Query, and Google Data Studio We are working to bring a few prior blog post to Achieve Data Solutions. We will not be including screen shots – though they may be added later. The video explains everything and the source code is available via the link […]

Continue reading