| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting control on userform with part of control name (set question) | Excel Programming | |||
| User Defined Variables in MS query cause a problem to import data | Excel Discussion (Misc queries) | |||
| Variables in a query | Excel Programming | |||
| Web Query with looping variables in the URL | Excel Programming | |||
| Converting strings to Sum worksheet function and control variables | Excel Programming | |||
Hybrid Mode
