View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DavidM DavidM is offline
external usenet poster
 
Posts: 20
Default 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