downloading query generated csv file

N

noname

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top