Exporting csv file from online database with a macro

[Tren2k]

Hi Guys

I have an online database which creates a csv export of accounts via clicking a form button. I can get excel to automate IE to click this button but i need a way of setting the filename and location it saves to.

Any help appreciated.

Thanks.