LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,560
Default VBA slows with time

Hi Group,

Hope all are having a good day. I have some code that does web queries. It
is sort of in 4 legs. It does a lookup of Fund ticker symbols and bring back
closes for a specific symbol and a specific single day. The list of symbols
is a little over 800.

It does this 4 times for 4 different dates, what I am calling legs. So 4
legs. Each leg about doubles the time of the previous leg. 2 minutes, 4
minutes, 5 minutes and 10 minutes. The query is deleted after each look up
and all names are also deleted.

When the macro is finished. Task manger indicated that Excel.exe is still
using 90% of memory. I am very perplexed at this situation.

Does anyone have any insights on this situation?
One of the other problems I am having is that when I leave this message and
check the box below "Notify me of replies", I do not recieve e-mail
notifications.

Thanks for your help,
David
 
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
Slows after about 1,000 records? Paul H[_2_] Excel Discussion (Misc queries) 3 June 3rd 09 01:21 PM
Row Height -- Slows VBA [email protected] Excel Programming 7 December 18th 08 09:47 PM
Loop slows down Andrew[_58_] Excel Programming 5 November 4th 08 10:45 PM
Filtering slows down a macro Curt D. Excel Worksheet Functions 1 October 13th 06 04:08 AM
macro slows down Gary Keramidas Excel Programming 1 January 21st 06 11:35 PM


All times are GMT +1. The time now is 05:19 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"