ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Question on Web Query .iqy Control Variables (https://www.excelbanter.com/excel-programming/400639-question-web-query-iqy-control-variables.html)

KJS

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?



All times are GMT +1. The time now is 02:23 PM.

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