I would like to make an excel macro that uses power query to load data to the excel file. The data file might not be an xls, it could be a csv, xml, or access file. I need to be able to use a different power query connector depending on the file. Is there any way for this to be done through vba or M?
Bookmarks