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

Resources:
--------------------------------------------------

Support Sigma Coding:
--------------------------------------------------

Related Topics:
--------------------------------------------------
Title: How to Work With Charts in Excel VBA | Part 3

Title: How to Work With Charts in Excel VBA | Part 1

Title: How to Work With Charts in Excel VBA | Part 2

Title: Working With Excel VBA Connection Objects | Excel OLEDB Connection

Title: Working With Excel VBA Connection Objects | Power Query Connections

Title: Working With Excel VBA Connection Objects | Workbook Connections Collection

Title: Using Offset In VBA

Title: Working With Pivot Tables In VBA | Part One

Title: Working With Pivot Tables In VBA | Part Two

Title: Working With Pivot Tables In VBA | Part Three

Title: Selecting Complex Ranges In VBA

Title: Selecting Ranges in VBA

Title: Selecting Workbooks in VBA

Title: Selecting Worksheets in VBA

Title: Looping Through Worksheets In VBA

**Amazon Associates Disclosure:
--------------------------------------------------

Tags:
--------------------------------------------------
#Excel #VBA #PowerQuery

[HeikoGrethe]

Many thanks for this excellent video! I have gone through this and the 2 earlier videos for creating data imports via VBA. Now I am feeling very well prepared for my tasks and could even generate all needed code while I followed your video! I was googling hours and hours for automated imports to EXCEL before – your 3 videos cover the topic totally! 😍

[mikelennon]

What is the best way to update the records in the source table/sheet form the Power Query ( like, adding records, deleting a record, Can we make a column properties ( one or more columns) a Hyperlink that be clicking it, a custom data entry form be opened to add, deleted or update the record/s in the source tables?

[JaviUTube]

What if I don't want to load the data to a worksheet but only use the connection to get the data and load it to a Combobox object for example?

[jacobaren]

The only thing that is disturbing with this is that when I add the query table, it's a "Connection only" instead of a table. I've tried to work it around but didn't succeed.

[priyankadesai]

Hi can we do as below when:-
Whenever Workbook is opened the Master Data sheet should be Locked & can be opened by individuals whoever knows the password.
2. When password is entered, Data sheet should be refreshed, updates the data & saves it.
3. Now data is refreshed-updated&saved into sheet, should again fall back to protection.
This should be functioning I'm expecting.
(Lock- Enter password- data Refresh & updated- Again Lock)
1. Click button
2. Enter password
3. Refresh sheet
4. save sheet
5. Lock sheet