ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can I run a Query from a cell using VBA (https://www.excelbanter.com/excel-programming/383017-can-i-run-query-cell-using-vba.html)

DavidM

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




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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com