Тёмный

VBA and Power Query 

Oakley Turvey
Подписаться 2 тыс.
Просмотров 3,8 тыс.
50% 1

A look at using VBA loops to create Power Queries from all the tables in a workbook.

Опубликовано:

 

15 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 7   
@ChristopheRigaud
@ChristopheRigaud Месяц назад
Thanks Oakley for the explanation. Any idea how to check if the loading of data is done correctly (Status: x rows loaded)?
@Aldrannt
@Aldrannt 7 месяцев назад
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
@BrainiacAdam
@BrainiacAdam 6 месяцев назад
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.
@kebincui
@kebincui 4 месяца назад
Great video 👍👍
@sy23453
@sy23453 10 месяцев назад
Thank you dear Oakley!
@javis5070
@javis5070 6 месяцев назад
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
@user-ti6es9bw7l
@user-ti6es9bw7l 8 месяцев назад
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.
Далее
Advanced Unpivoting Tricks in Power Query
30:19
Просмотров 17 тыс.
Power Query - Avoid "Helper Queries" (+10 Cool Tricks)
18:40
КТО БОИТСЯ КЛЕЩЕЙ?? #shorts
00:18
Просмотров 2,1 млн
38 - Convert Query to a Function in Power Query
14:00
Power Query Using VBA and Sql To Import Text File.
39:57
How to use Microsoft Power Query
16:35
Просмотров 1,9 млн
List.Accumulate Case Study in Power Query
13:23
Просмотров 23 тыс.
Use Excel VBA to Read API Data
20:48
Просмотров 137 тыс.