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

Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...
This video explains how to use a macro that I created to speed up the process of creating connections for all tables in a workbook. This is helpful when you are trying to merge or append tables in Power Query and don’t want to create connections one by one. This macro is free for you to copy and use.

The VBA code for the macro can be found in the corresponding blog post for this video on my website. You can find it here: https://www.excelcampus.com/vba/power...
connection-only-all-tables

Related Videos:
How to Combine Excel Tables or Worksheets with Power Query:
   • How To Combine Excel Tables And Works...  
Power Query Overview - Automate Data Tasks in Excel & Power BI:
   • How To Automate Data Tasks In Excel U...  
How to Install Power Query in Excel 2010 or 2013 for Windows:
   • How To Install Power Query For Excel ...  
How to Create a Personal Macro Workbook in Excel and Why You Need It:
   • How to Create a Personal Macro Workbo...  
How to Create Yes/No Message Boxes for VBA Macros:
   • How to Add a Yes No Pop-up Message Bo...  
How to Add Macro Buttons to the Excel Ribbon or Quick Access Toolbar:
   • How to Add Macro Buttons to the Excel...  

Webinar: Free Excel Training on The Modern Power Tools
https://excelcampus.easywebinar.live/...

#MsExcel #ExcelCampus
00:00 Introduction
00:51 Run the Macro
02:20 VBA Editor