Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
PWS PWS is offline
external usenet poster
 
Posts: 18
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
opens slowly boopathi subramaniam Excel Discussion (Misc queries) 1 June 2nd 10 02:14 PM
Excel starts very slowly THIBUS Trévis Setting up and Configuration of Excel 4 November 27th 09 02:28 AM
Excel starts very slowly THIBUS Trévis Excel Discussion (Misc queries) 0 November 19th 09 10:14 PM
Looking for Excel site similar to "The Word MVP Site" Doug New Users to Excel 1 January 25th 09 12:46 PM
Spreadsheet opens very slowly Rich W. Excel Discussion (Misc queries) 5 May 19th 08 07:36 PM


All times are GMT +1. The time now is 04:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"