Export to excel from Web page

Hi all,

I have a web page contains filtered result in a table format(1 of 265 Miltiple pages).
The web page has 'export to excel' option to export the entire table to excel file.

When i click 'export to excel' it will start downloading the excel file, for that i need to give the location ( As usual how we downlaod any file from website).

Can any one clarify me how to do this usig VBA Macro?

Thanks in Advance.


Regards
Velmurugan K

Hi Paul,

Thanks for the quick reply.....

in my case, The webpage contains multiple pages for the single table. i can read the table via coding by pressing next button from the page. and it is taking more time when the number of records goes beyond 10000.

ther one option in the same page by which we can download the whole data in excel format. when i press the 'Export to Excel' Button the normal downloading procedure starts.

I just want to control the downloading widows to make it faster....

Thanks anyways...