Posted to microsoft.public.excel.programming

G[_6_]

external usenet poster

Posts: 3

Programmatically pass query params

Trying to run a query several times, each time with a new parameter. The
query can be easily refresh by selecting the cell and background refreshing
the query, as I found by recording a new macro. The macro record does not
capture the change to the cell that contains the param.

Any ideas?

THanx.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Passing Params to Embedded query programmatically	G[_6_]	Excel Programming	1	February 15th 05 01:43 PM
How to pass a date in Excel to ms query	Vince	Excel Programming	0	June 16th 04 10:08 PM
How to pass a date in Excel to ms query	Tom Ogilvy	Excel Programming	0	June 16th 04 04:26 PM
Pass Parameter to Access Query	Al	Excel Programming	3	April 29th 04 10:15 AM
Pass a filename to a query	Mike Fogleman	Excel Programming	1	December 25th 03 10:26 PM

All times are GMT +1. The time now is 01:37 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us