HOW TO GET POWER QUERY IN EXCEL 2019 CODE

Excel.CurrentWorkbook() is the Excel function which points to contents within the workbook.

‘File1’ is the name of our custom Power Query object, and is the named cell in the worksheet containing the file path and file name.

HOW TO GET POWER QUERY IN EXCEL 2019 CODE

Open the Power Query Advanced Editor from the Home tab in the Power Query window Note the comma at the end of the first two lines The three lines of code explained: Power Query: create the object to define the FILE PATHįilePath = Excel.CurrentWorkbook(),

Enter the three lines of code shown below, under the default ‘let’ section:.

Open a blank query, open the Advanced Editor window, and.

First, enter your file path and file name details into a worksheet in your Excel workbook, as described above.

So, we create custom Power Query objects to link to dynamic file paths and file names.

Note that Power Query doesn’t provide a built-in way to get the path for the current workbook, so another method is required. The target worksheet is displayed and the named cell or range is highlighted.Ĭreate Power Query objects to get file paths from cells in the current workbook To go directly to any named cell or range in an Excel workbook, click in the ‘Name box’, enter the name, and press Enter. To create a named range of cells, select a range of cells, and then name the range (not applicable to this method for creating dynamic file paths in Power Query).Note, your cursor will return to the highlighted cell.

Your name reference replaces the default cell reference.Enter the name you want to refer to the cell by, then press Enter.Click in each cell, then click in the ‘Name box’ (top left box above the worksheet grid).Enter your file name into a cell, repeat for additional file names.Enter your file path into a cell, repeat for additional file paths.Go to the worksheet where you are going to save the custom file path and file name(s).

How to get power query in excel 2019