Excel - How to check Power Query runtime with VBA | Power Query 12
In this Excel tutorial, you will learn how to check Power Query runtime with VBA | Power Query 12
Want to get 3 chapters of the Excel SuperHero book? Sing up: https://ExcelAndAdam.com/book
VBA code:
Sub RunTime()
Dim tZero As Double
tZero = Timer
'Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False
ActiveWorkbook.Connections("Query — Combine").Refresh
MsgBox "Query was executed for: " & Timer - tZero & " seconds"
End Sub
---⏱️Timestamps⏱️---
00:00 | Indtroduction VBA code to check Query runtime
01:10 | VBA code with BackgroundQuery = FalseQuery
01:46 | VBA code refreshing query by name
03:28 | Close
================
Files to download in the Eng folder on the website:
http://exceliadam.pl/youtube
You can also find me on:
📚Blog - https://excelandadam.com/
🍀Instagram - https://www.instagram.com/excelandadam/
🌟Tik Tok - https://www.tiktok.com/@excelandadam
✨Facebook - https://www.facebook.com/ExcelAndAdam
🕊Twitter - https://twitter.com/ExcelandAdam
#ExcelAndAdam #ExcelTips #excel
Видео Excel - How to check Power Query runtime with VBA | Power Query 12 канала Excel and Adam
Want to get 3 chapters of the Excel SuperHero book? Sing up: https://ExcelAndAdam.com/book
VBA code:
Sub RunTime()
Dim tZero As Double
tZero = Timer
'Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False
ActiveWorkbook.Connections("Query — Combine").Refresh
MsgBox "Query was executed for: " & Timer - tZero & " seconds"
End Sub
---⏱️Timestamps⏱️---
00:00 | Indtroduction VBA code to check Query runtime
01:10 | VBA code with BackgroundQuery = FalseQuery
01:46 | VBA code refreshing query by name
03:28 | Close
================
Files to download in the Eng folder on the website:
http://exceliadam.pl/youtube
You can also find me on:
📚Blog - https://excelandadam.com/
🍀Instagram - https://www.instagram.com/excelandadam/
🌟Tik Tok - https://www.tiktok.com/@excelandadam
✨Facebook - https://www.facebook.com/ExcelAndAdam
🕊Twitter - https://twitter.com/ExcelandAdam
#ExcelAndAdam #ExcelTips #excel
Видео Excel - How to check Power Query runtime with VBA | Power Query 12 канала Excel and Adam
Excel Microsoft Excel Excel and Adam ExcelAndAdam excel formula and functions excel tips excel tip excel trick excel tricks excel tutorial ExcelTips Excel Discoverer Power Query PowerQuery How to check Power Query runtime with VBA VBA code to check Query runtime VBA code with BackgroundQuery = FalseQuery VBA code refreshing query by name Timer Time QueryTable Connections
Комментарии отсутствуют
Информация о видео
29 мая 2025 г. 12:09:00
00:03:36
Другие видео канала
