VBA and Power Query

preview_player
Показать описание
A look at using VBA loops to create Power Queries from all the tables in a workbook.
  1. Oakley Turvey
Рекомендации по теме
Vba Macro To 0:08:50

Vba Macro To Create Power Query Connections For Any Table In Excel!

VBA and Power 0:20:39

VBA and Power Query

Power Query Replaces 0:01:00

Power Query Replaces XLOOKUP?!

How to use 0:16:35

How to use Microsoft Power Query

Python in Excel 0:10:05

Python in Excel vs. VBA - What You Should Learn in 2024!

How to easily 0:17:10

How to easily automate boring Excel tasks with Power Query!

Automate your Excel 0:08:54

Automate your Excel work with Power Query | Alternative to Coding Language VBA !!!

How Power Query 0:09:02

How Power Query Will Change the Way You Use Excel

Amazon Web Scraping 0:35:44

Amazon Web Scraping using Excel, VBA & Power Query

Business Intelligence: Automating 0:04:35

Business Intelligence: Automating Power Query with VBA

How to Combine 0:09:57

How to Combine Multiple Excel Files using Power Query

You WON'T BELIEVE 0:12:17

You WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query 🤯

RIP: MY EXCEL 0:15:22

RIP: MY EXCEL VBA CAREER (2008-2024)

Extract and Transform 0:09:51

Extract and Transform SAP Data with ONE click! Automation with Excel VBA and Power Query

Do you need 0:00:39

Do you need VBA ?

Do You Need 0:13:02

Do You Need to SWITCH from Excel VBA Macros to Office Scripts?

Automating the Power 0:07:47

Automating the Power Query Refresh Using VBA

Learn Excel VBA 0:14:02

Learn Excel VBA to Automate Anything

C'est quoi Power 0:06:27

C'est quoi Power Query ? L'outil qui remplace le VBA

Microsoft Power Query 0:07:18

Microsoft Power Query + VBA! Refresh query each time selection changes!

Working With Excel 0:39:00

Working With Excel VBA Connection Objects | Power Query Connections

Stop Doing Manual 0:16:18

Stop Doing Manual Reconciliations in Excel: Use Power Query

Automate reconciliations with 0:09:37

Automate reconciliations with Power Query | Excel Off The Grid

Pro Tip - 0:13:33

Pro Tip - Ditch Excel VBA for Power Query to Automate Excel Dashboards

Комментарии
Автор

I was wondering if you could do a video talking about your experience as Eliminator and maybe share some behind the scenes. I’d love to see that. I have a new episode of Eliminator tonight if you are interested. Feel free to catch up to the other ones I did too.

BrainiacAdam
Автор

great, i will try, i have been working with recordsets instead of python, and the option from this video will give me more options in my project

Aldrannt
Автор

Great videos! Thank you very much. I wonder.. is there any way to use a VBA function inside Power Query (as in add custom column)? Thanks in advance

javis
Автор

Thanks Oakley for the explanation.
Any idea how to check if the loading of data is done correctly (Status: x rows loaded)?

ChristopheRigaud
Автор

Is there a way to develop a macro that can update the query source within the Power Query Editor? I have tables that are formatted the same but with different data based on region. I want the user to be able to select the region of data they want to view.

TaylorBates-bm
welcome to shbcf.ru