This is a webpage which opens a CSV file and displays the data in a table on the webpage (page is from Yahoo Finance, stock symbol MSFT):
http://table.finance.yahoo.com/table.csv?a=3&b=27&c=2002&d=6&e=28&f=2002&s=msft&y=0&g=d&ignore=.csv
I'd like to be able to prompt the user for a stock symbol using a Dialog Box, and then have my macro read the corresponding CSV file. I already have the program able to read a CSV file if it's on my hard drive, but how can i use the data coming from a web source (instead of a file on my hard drive)?
I'm not married to using the above method/website, just thought i'd add it to aid anyone that could help.
Thanks for any help OR pointing me in the right direction!
http://table.finance.yahoo.com/table.csv?a=3&b=27&c=2002&d=6&e=28&f=2002&s=msft&y=0&g=d&ignore=.csv
I'd like to be able to prompt the user for a stock symbol using a Dialog Box, and then have my macro read the corresponding CSV file. I already have the program able to read a CSV file if it's on my hard drive, but how can i use the data coming from a web source (instead of a file on my hard drive)?
I'm not married to using the above method/website, just thought i'd add it to aid anyone that could help.
Thanks for any help OR pointing me in the right direction!