Auto save of csv download

**wmorton** · 01-14-2008, 03:55 PM

Hello,

I am using the FollowHyperlink command in VB to access a large series of csv files from a website. Every time I download a file, Excel asks me to either Save, Open or Cancel the download. How can I automate the Save process so that my macro can uniquely save each downloaded csv and move on to the next?

Is their perhaps some code that will allow the download to save as default without the pop up window appearing at all?

Thanks in advance,

wmorton

**chucklod** · 01-14-2008, 05:25 PM

Here are a couple possibilities:

- DisplayAlerts can turn on and off some dialog boxes. I'm no certain if yours is one of them.

- Try using Sendkeys to automatic pressing the Save button.

Good luck,
Chuck L

**vilasc** · 11-09-2012, 03:29 AM

I have some issue can any one help when i click on download button it show three option open save and cancel, i wan to save the file using vba, i dont want to use send keys in that senario.

**arlu1201** · 11-09-2012, 07:06 AM

vilasc,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.