Hi,
I'm trying to download a CSVfile from a webpage directly into excel.
this is the URL from the webpage:
http://online.wsj.com/mdc/public/page/2_3024-NYSE.html?mod=mdc_h_usshl
on that page it has a "save to spreadsheet" link with the following URL:
http://online.wsj.com/public/resources/documents/NYSE.CSV
Now when I click on "save to spreadsheet" I get the usual pop-up with the question "save as" .... . Is there a way so write some VBA-code that I can attach to a button that takes out that manual intervention?
thanks in advance for your input
Regards
JL
I'm trying to download a CSVfile from a webpage directly into excel.
this is the URL from the webpage:
http://online.wsj.com/mdc/public/page/2_3024-NYSE.html?mod=mdc_h_usshl
on that page it has a "save to spreadsheet" link with the following URL:
http://online.wsj.com/public/resources/documents/NYSE.CSV
Now when I click on "save to spreadsheet" I get the usual pop-up with the question "save as" .... . Is there a way so write some VBA-code that I can attach to a button that takes out that manual intervention?
thanks in advance for your input
Regards
JL