View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] briana.kobor@gmail.com is offline
external usenet poster
 
Posts: 3
Default Automate Excel download of csv file without proper URL?

I am looking for a way to automate downloading natural gas market data
that is available he

https://www.services.nymex.com/otcse.../OTCSettle.jsp

The Usage agreement must be agreed to and then the link "Download all
available OTC settlement data" must be clicked prompting a CSV
download. I then need to copy this all into an excel sheet and can
take it from there.

Note: the link that prompts the download doesn't have a URL but is
"javascript:__doPostBack('ctl00$btnExport','') "

Is there a way to do this with web query?

Help is much appreciated. Thanks.