Now go to Home and click on Close & Load. This picture shows how things should now look: = Xml.Tables(Web.Contents('' & Excel.CurrentWorkbook() & '&hoursBeforeNow=1')) edit the formula bar text to the text shown below - make sure to change the name of the Excel range shown at Name='StationName' to whichever name you have used.the entry in the formula bar is too long to display so click on the V symbol at the end of the formula bar to expand it.make sure that the formula bar is displayed by going to View then checking Formula Bar.the first entry in the Query Settings panel should be Source - click on that entry to select it.look for the Query Settings panel at the right of the screen - if it's not there, go to View then click on Query Settings.select any cell in the data table from the current query.Secondly, we need to incorporate the named range into the source for the query. I used 'StationName' as the name of the range but you can use any name you like. Adapting from this answer, this is a two-step process.įirstly, create a named range for the cell that stores the value you will pass to the query.
