Controlling ODBC queries with VB variables
 

::bump:: any help would be appreciate

--
vehemen
-----------------------------------------------------------------------
vehement's Profile: http://www.excelforum.com/member.php...fo&userid=1541
View this thread: http://www.excelforum.com/showthread.php?threadid=27022

Controlling ODBC queries with VB variables
 

Try this:

' At the top of the sub
Dim Var As String
Var = "BEST"
'
'
'
"WHERE (`ORDER PROJECTIONS`.LB4= " & Var & ")"




"vehement" wrote in message
...

::bump:: any help would be appreciated


--
vehement
------------------------------------------------------------------------
vehement's Profile:
http://www.excelforum.com/member.php...o&userid=15417
View this thread: http://www.excelforum.com/showthread...hreadid=270221