Responding to Browser prompt

[durrenm]

Not sure if this is the correct forum for this question. I'm working in VBA - Excel (2010)

I'm attempting to download a CSV file from a web based data logging system. Unfortunately, the system does not provide the URL to the CSV file. Instead, the URL triggers a CGI Script (the URL looks something like this - http://www.vendortool.com/cgi-bin/cg...d=site_ID=1071)

After sending this URL, the browser responds with a dialog box (hopefully, shown below)



My choices are "open with Excel" or "Save File"

How do I automatically start the download and capture the subsequent CSV data (I don't need to save the data, just process a few numbers)

I should note, that I'm doing this on a Windows 7 machine with Office 2010 and I'm creating an instance of Explorer and sending the URL (the Firefox graphic above was for illustration only) I have no difficulty capturing the page that comes down just before the csv dialog box is presented :-(

Thanks in Advance,
Mark

[westconn1]

Not sure if this is the correct forum for this question.

the same question has been asked here before, with solutions, some by me