Forum Discussion
How to amend multiple source files by different power query
Hello all, is there any way how to amend different source files in one XLS file ? I have one file with 9 sheets, for every sheet I did amend power query editor. But problem is that I need to...
Hello - yes, this can easily be done. Your scripts may currently be using the Excel.CurrentWorkbook connector. This will need to be changed to Excel.Workbook and add the file name, object kind (Sheet, Table) and the object name. You can edit this in the Advanced Editor for the queries.
Hello - yes, this can easily be done. Your scripts may currently be using the Excel.CurrentWorkbook connector. This will need to be changed to Excel.Workbook and add the file name, object kind (Sheet, Table) and the object name. You can edit this in the Advanced Editor for the queries.