Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Site Loading Slowly
I have written the code below in a loop that opens various web pages on
the company intranet: sISIN = rCell.Value Set wbksource = Workbooks.Open(Filename:= _ "http://structuredproducts/en/searchResults.do?IDENT=" & sISIN) .... wbksource.Close False My issue is that the time taken to open each file in each iteration is vastly different. At some times each iteration takes about 5 seconds, at others times it takes, well too long to wait. There is other code in the loop but this executes in the blink of an eye, the delaying factor is opening the web page. Can anyonr suggest why this is happening (or may another group that might be better served considering this matter) PWS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opens slowly | Excel Discussion (Misc queries) | |||
Excel starts very slowly | Setting up and Configuration of Excel | |||
Excel starts very slowly | Excel Discussion (Misc queries) | |||
Looking for Excel site similar to "The Word MVP Site" | New Users to Excel | |||
Spreadsheet opens very slowly | Excel Discussion (Misc queries) |