View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KJS KJS is offline
external usenet poster
 
Posts: 2
Default Question on Web Query .iqy Control Variables

There appear to be several control variables which can follow the URL and
parameters in a Web Query .iqy file. These are the ones I've seen in various
examples:

Selection = EntirePage/Numerical List (eg: 22,23,24)
Formatting = All/None
PreFormattedTextToColumns = True/False
ConsecutiveDelimitersAsOne = True/False
SingleBlockTextImport = True/False
DisableDateRecognition = True/False
DisableRedirections = True/False

I have been experimenting with different values of these variables, and none
of them seem to alter the retrieved data at all. In particular, I always get
the entire page regardless of the value of "Selection". Can someone
enlighten me about this?