PDA

View Full Version : scrape excel sheet embedded in an intranet page



philfer
07-08-2014, 08:07 AM
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
07-08-2014, 11:45 AM
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
07-09-2014, 06:15 AM
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
07-09-2014, 09:03 AM
Look at the source code of the webpage.