Hello Everyone
Usually the statement is like: Select * from sheet1$$] where etc etc
I need the sheet1 to be a variable, the sheet changes with each excell book I bring in and there are lots
I tried e$SheetNameHere$] that did not work, even when I remove the square brackets.