Cell value for Query

[Guest]

Hi All......
I have a line of code used to run a MSQuery. It works fine as is, but I
would like to extract the hard coded 165167 and instead obtain it from a cell
value or preferably from an InputBox............
Here's the code snippet......

& Chr(10) & "WHERE (WO.WONUM='165167')" _

Any help would be much appreciated........

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

& Chr(10) & "WHERE (WO.WONUM='" & Range("A1").Value & "')" _

would be one way. Range("A1") can be replace with inputbox.

There is also a parameter query option with a query table. This is part of
the definition of query, so it can pop up its own box or get the value from a
cell.

See these links for that possibility

http://nickhodge.co.uk/gui/datamenu/dataexamples/externaldataexamples.htm

http://www.dicks-clicks.com/excel/ExternalData6.htm#Parameters

 

[Guest]

Thanking you very much, kind Sir, worked like a charm...............it's good
to see you!

Vaya con Dios,
Chuck, CABGx3