downloading query generated csv file
 

I am trying to download using VBA a query generated csv file from IE.
the csv file is generated on the fly from a query run on the database
on the remote server. the query is run when i tick a checkbox & then
click a download button on an IE webpage. this opens a new IE (no
addressbar) webpage which then shows a progress bar & then finally
displays a Open/Save dialog box to download the file to the local
drive.

How do i grab the instance the csv file is created & then download it
to a specific folder on my local drive without getting the Open/Save
dialog box.

P.S: I donot have the URL for the remote server or the query.

Cheers!