View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Erik BZ[_2_] Erik BZ[_2_] is offline
external usenet poster
 
Posts: 2
Default 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