| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell value to replace hard code in Query
Hi All........
I have a macro that includes a Query that I have recorded and works fine. It has hardcoded values in place for this section...... WHERE (Q509M.Planner='LQ'.... I would like to be able to have a cell value replace the 'LQ' part. I have tried numerous combinations and no joy. I sucessfully use DBQ=" & NewFile & ";" in another part of the same Query and it works fine to insert a Range().value assigned to NewFile, but just can't seem to get this WHERE thing to cooperate. Any help would be much appreciated. Vaya con Dios, Chuck, CABGx3 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace a word with hard return code | Excel Programming | |||
| Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
| Seeking the character code for entering a Hard Return in a cell? | Excel Discussion (Misc queries) | |||
| how to replace a hard return? | Excel Programming | |||
| Replacing hard code with reference to a cell value | Excel Programming | |||
Threaded Mode
