Posted to microsoft.public.excel.programming

external usenet poster

Posts: 20

Can I run a Query from a cell using VBA

Hi

I have a column of Queries in a column A starting in A1 with a blank row
between each query.
Can I use VBA to run one of those Queries from A1 to a new sheet then stop.

WEB
1
file:///C:/ALL/Test1.html
Selection=EntirePage
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=True
DisableRedirections=False

Thanks in advance

DaveM

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
How to use the value in a cell to run a query	Bob1866	Excel Discussion (Misc queries)	1	August 29th 09 11:20 PM
Cell Protection Query	Sue C	Excel Discussion (Misc queries)	15	March 6th 09 04:07 PM
Go to cell - Query	Bill	Excel Worksheet Functions	5	June 30th 08 12:03 AM
Query on Cell	VIVEKMANE	Excel Discussion (Misc queries)	1	December 7th 07 10:06 AM
Cell value for Query	CLR	Excel Programming	2	August 10th 06 08:03 PM

All times are GMT +1. The time now is 09:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us