Automate Power Query with VBA - Taking Power Query to the Next Level

Sign up for our free Insiders program and get the example file: Click here: https://exceloffthegrid.com/insiders-... File Reference for this video: 0262 Automate Power Query with VBA ★ Want to become an Excel ninja? Check out our training academy ★ https://exceloffthegrid.com/ ★ About this video ★ With the rise of Power Query, many users have shifted away from VBA entirely. But there is a gap... what if we want to automate Power Query? That’s where the old-school magic of VBA comes back in. In this video, we bring the best of both worlds together. You'll see three practical examples of how to use VBA to automate and enhance your Power Query workflows. Whether you're refreshing queries, changing privacy levels or using custom functions, this video will show you how to save more time. You’ll get access to the full VBA code shown in the video, so you can follow along and implement these ideas in your own projects. If you've ever wished Power Query was just a bit more flexible, this is the solution you've been waiting for. 00:00 Introduction 00:41 [1] Background refresh toggle 02:06 Set up a personal macro workbook 03:20 [2]m Privacy level toggle 04:24 Become awesome at Excel 04:46 [3] Insert custom function 6:45 Custom ribbon 8:27 Using the macros 10:40 Wrap-up ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter:   / exceloffthegrid   #MsExcel