Forum Discussion
PowerQuery Question: = Folder.Files() opens all sheets in Workbooks
I’m automating a PowerQuery to open monthly reports. blank query for “FolderLocation” where I store new = Folder.Files(FolderLocation) to open them (but I only want ONE sheet not all sheets)...
I think I figured it out! During one of my steps, I just filter the column to eliminate the ones I don’t want.
-mm
-mm