[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

web query files



PureBytes Links

Trading Reference Links

Excel 97 Web query files are text files. They are little short instructions
on what page to access on the Web and what data to extract while there.

Sample queries are kept in "C:\Program Files\Microsoft Office\Queries"

They have an ".iqy" extension.

If you downloaded Dave Steppan's stock/fund downloader from

http://www.geocities.com/SiliconValley/Network/1030/ExcelTop.html

go into the Macro and Visual Basic file to see how he uses them.

go to "tools ---> macro --> visual basic editor"

in the top left box -- click on "VBA project (MutFunds.xls)"

then press print, you'll get 10 to 12 pages of all of the code

One page one of the "Module 1" Sub GetFundQuotes()
you''ll see that he uses the "\GetWebData.igy" query file

- 0 -

These macros and Visual Basic code are the basis that you can us for
apersonalized automated system

Best regards

Walter