changing value in query using macro

S

Steve Schapel

Tang,

You can't really do this with a macro. You can do it in a VBA procedure
by opening a QueryDef object and setting its SQL property of the desired
string.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro warning in word 1
Change Microsoft A3 license users to A1 by power shell script 0
Drop down list control value in vba 2
Need Help with Macro Security 1
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Macro to select and delete levels of a document 2
VBA word change keys 0
How to Change criteria on a saved query using VBA 0

Top