My employer has emasculated Excel 2016 by deactivating VBA and macros. But for a work-related side-project of mine, I need to import some 275 TXT files into Excel, ideally resulting in 275 or so worksheets or workbooks--one for every TXT file.
Can that be done without VBA or macros?
Power Query allows me to import the files, but I have not discovered a way to do it in one fell swoop. So I'm reduced to importing all the files "from folder" and filtering and loading them one by one in the "edit" mode.
Is there a way for me to define the imporation parameters once in Power Query, and then let Power Query perform the importation of all files in one go?