Serving the Quantitative Finance Community

 
User avatar
Martingale
Topic Author
Posts: 1
Joined: November 15th, 2001, 7:54 pm

get data from websites using VBA

December 18th, 2002, 8:18 pm

It is always good to know more cool stuff, quantie. Merry Xmas to all!
 
User avatar
A
Posts: 1
Joined: November 19th, 2001, 7:27 pm

get data from websites using VBA

December 18th, 2002, 11:27 pm

QuoteOriginally posted by: MartingaleIt is always good to know more cool stuff, quantie. Merry Xmas to all!I have done it in VB, using the INET control to open the HTML web doc. If the INET control is available in VBA you can try it as well.
 
User avatar
mdt
Posts: 0
Joined: October 3rd, 2001, 12:24 pm

get data from websites using VBA

December 23rd, 2002, 2:11 pm

The following knowledge base article is usefulhttp://support.microsoft.com/default.aspx?scid=kb;en-us;244757It uses the URLDownloadToFile API call to save a file to disk.