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
|