Working With Excel VBA Connection Objects | Power Query Connections

Let’s move on to a prevalent type of connection, a connection to a Power Query “Data Query”. With Power Query, we can aggregate data from different sources and mash them up into a single source. Most people aren’t aware that they can leverage these queries as workbook connections and even use them inside of their workbook using VBA. In this video, we focus on connection to queries using a connection object in the Excel VBA object model. Video Resources: -------------------------------------------------- Resource: GitHub File Link: https://github.com/areed1192/sigma_co... Resources: -------------------------------------------------- Facebook Page:   / codingsigma   Facebook Group:   / sigmacoding   GitHub Sigma Coding: https://github.com/areed1192/sigma_co... Support Sigma Coding: -------------------------------------------------- Patreon:   / sigmacoding   Amazon Associates: https://amzn.to/3bsTI5P ** Related Topics: -------------------------------------------------- Title: How to Work With Charts in Excel VBA | Part 3 Link:    • How to Work With Charts in Excel VBA | Part 3   Title: How to Work With Charts in Excel VBA | Part 1 Link:    • How to Work With Charts in Excel VBA | Part 1   Title: How to Work With Charts in Excel VBA | Part 2 Link:    • How to Work With Charts in Excel VBA | Part 2   Title: Working With Excel VBA Connection Objects | Excel OLEDB Connection Link:    • Working With Excel VBA Connection Objects ...   Title: Working With Excel VBA Connection Objects | Power Query Connections Link:    • Working With Excel VBA Connection Objects ...   Title: Working With Excel VBA Connection Objects | Workbook Connections Collection Link:    • Working With Excel VBA Connection Objects ...   Title: Using Offset In VBA Link:    • Using Offset In VBA   Title: Working With Pivot Tables In VBA | Part One Link:    • Working With Pivot Tables In VBA | Part One   Title: Working With Pivot Tables In VBA | Part Two Link:    • Working With Pivot Tables In VBA | Part Two   Title: Working With Pivot Tables In VBA | Part Three Link:    • Working With Pivot Tables In VBA | Part Three   Title: Selecting Complex Ranges In VBA Link:    • Selecting Complex Ranges In VBA   Title: Selecting Ranges in VBA Link:    • Selecting Ranges in VBA   Title: Selecting Workbooks in VBA Link:    • Selecting Workbooks in VBA   Title: Selecting Worksheets in VBA Link:    • Selecting Worksheets in VBA   Title: Looping Through Worksheets In VBA Link:    • Looping Through Worksheets In VBA   **Amazon Associates Disclosure: -------------------------------------------------- I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One of the ways I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) but also helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel. Tags: -------------------------------------------------- #Excel #VBA #PowerQuery