wrote in message
...
On Nov 7, 1:39 pm, Michael wrote:
Assuming the sheet you want is the first sheet in your workbook,
myvar=myvar = Sheets(1).Name

Then substitute your variable:

" " & "WHERE Projects.Project_Number="& myvar & ";"

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.



- Show quoted text -

I get the error that characters are found at the end of the SQL
statement

Drop the semicolon at the end.

Tim