I can't believe how difficult this seemingly simple task has turned out to be. I need to be able to get a date value stored in an Excel spreadsheet (say, C:\\Temp\\file.xls) in cell B28, and put ...

I had to update my query today to change the Excel tab name because they updated the file source and were now sending it as "Sheet1", so I updated my query "table" as "Sheet1$".