Skip to main content

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.

@The Automator  what error you are getting ?


The Microsoft Access database engine could not find the object - after the word object in single quotes was the value of the variable then it goes on to say make sure the object exists.

The name it mentions is the correct sheet name, it does successfully open the spreadsheet.

 


Reply