Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
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-query-
connection-only-all-tables

Related Videos:
How to Combine Excel Tables or Worksheets with Power Query:
https://www.youtube.com/watch?v=HcfKOusOJhA
Power Query Overview - Automate Data Tasks in Excel & Power BI:
https://www.youtube.com/watch?v=vq9AgAtSvQg
How to Install Power Query in Excel 2010 or 2013 for Windows:
https://www.youtube.com/watch?v=gwW2CDdvUUs
How to Create a Personal Macro Workbook in Excel and Why You Need It:
https://www.youtube.com/watch?v=rD2-mSbTuL0
How to Create Yes/No Message Boxes for VBA Macros:
https://www.youtube.com/watch?v=rCh7ki9yVsM
How to Add Macro Buttons to the Excel Ribbon or Quick Access Toolbar:
https://www.youtube.com/watch?v=dmdolFcS-fI

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

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