scrape excel sheet embedded in an intranet page

[philfer]

Hello,

We have an intranet page that has an excel sheet embedded into it with rates on it and I want to automate the connection to this page to download the published rates daily.

I tried a web query but it says Javascript is disabled even though active scripting is set to "enable" in both my browser and the intranet page when I view it.

I tried the querytables.add method and it scraped all the headings and titles on the web page except the data in the excel sheet that is in it

I was hoping someone would have some better ideas how I can do this

Many thanks in advance
Phil

[snb]

You can connect to any Excel file in Internet using e.g.

Tab Data/ option From access/ filename http://www.snb-vba.eu/bestanden/0_plc-testvellen.xls

[philfer]

Hello snb,

That was a great tip. What would I do if I dont know the name of the excel sheet/workbook thats embedded in the webpage...............besides cry!!!

Cheers
Phil

[snb]

Look at the source code of the webpage.