Yes - for a text field you need the ' delimiter:
[vba]szSQL = "SELECT * FROM [" & SourceSheet$ & "$" & SourceRange$ & "] WHERE [Team_Leader] = 'XAZ80';"[/vba]
Yes - for a text field you need the ' delimiter:
[vba]szSQL = "SELECT * FROM [" & SourceSheet$ & "$" & SourceRange$ & "] WHERE [Team_Leader] = 'XAZ80';"[/vba]
Be as you wish to seem
Posting Permissions
Reply With Quote