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
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