VBA vs. Power Query
What's better: VBA (macros) or Power Query?
Want to become a professional Power Query developer?
Then you're here: https://online.powerexcel.training
Free online course "Power Query Basics": https://online.powerexcel.training/trial
This video will answer the following questions:
What can Power Query do?
What is the main purpose of Power Query?
What tasks have migrated from VBA to Power Query?
Is VBA completely obsolete and no longer needed?
What can Power Query NOT do that VBA can?
Author:
Sergey Ozhiganov
Microsoft Certified Trainer
Excel Expert
Excel Automation Developer
Additional videos on this topic:
"Event Handling" • VBA: Обработка событий
"VBA feat. Power Query" • VBA feat. Power Query
Addition to 0:15:50
I found this a long time ago :-)
There's a way to check for queries in a file using PQ