Can I run a Query from a cell using VBA

D

DavidM

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
 

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

Question on Web Query .iqy Control Variables 0
How to use symbol=["Ticker" "Enter ticker"] with Microsoft Excel 2 1
Web Query Doesn’t Load Unless I Open It 1st 1
Web Query, Help! 1
VBA Export to PDF 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Please Help...Multiple web queries and Macro help needed! 0
Series of web queries: Autofill? 1

Top