I dont think xls Files work with power query.
if the file can be extracted as txt, csv or xlsx power query would be perfect.
Otherwise i think you would have to go down the macro route.
A Macro could be as simple or as complex as you want to make it. To just open a spreadsheet and copy 1 sheet to an other work
The attached is very much a starter - you can add the file name & location etc on the data worksheet and then import. It is very basic and doesnt check for the file or anything else it just imports the sheet.
But it should give you a pointer
Last edited by Purfleet; 08-30-2020 at 01:31 PM.
Reason: typo
|