Help Needed for Macro-Write Yahoo Finance Live data to CSV file in C:\Test.csv

[bobby6910]

Hello Senior Members,
I request some senior member to please help.
I have put the following code in Excel
http://download.finance.yahoo.com/d/quotes.csv?s=^DJI+AA+AXP+BA+BAC+CAT&f=st1l1v&ignore=.csv
which downloads the Current data in Quotes.CSV file (opened new everytime I clk this link).
My simple requirement for help, as follows:
1) I want the o/p to be automatically stored to c:\Quotes.csv - which will not be open. It will be closed and data getting updated automatically.
2) How to re-run this code every 10 seconds?
3) When I clk the above link, a dialog box is shown :
"Opening http://download.finance.yahoo.com/d/quotes.csv?s=%5eDJI+AA+......+CAT&f=st1l1v&ignore=.csv
Some files may contain virus,...
Would you like to open? Y / N"
How to suppress this automatically and ensure that the data automatically starts updating?

Requesting help from senior members please.

warm regards...Bobby

 

[bobby6910]

Hello Senior Members,
Pls help .....
warm regards...Bobby