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 [$SheetNameHere$] that did not work, even when I remove the square brackets.