![]() |
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