LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
MD MD is offline
external usenet poster
 
Posts: 26
Default Memory Leak

Good day all you VBA addicts,

I'd like to know if anyone has heard about a memory leak. It accurs when
running VBA codes in conjunction with remote desktop ? This leak makes the
codes very unstable and has a 50/50 chance of working correctly or ending
prematurly.

I called MS in CA., they sent me a Hot-fix for the remote connection but
they said that it could like it couldn't work...it didn't.

I use a very simple but very long VBA code that cuts and pastes between 2
files. The code is about 8000 lines long on 15 subs. I've incorporated
plenty of cutcopy mode false to clear the clipboard. I also turned off the
MSOffice clipboard in the registry. This is not a local event. It occurs
on well over 30 computers we have.

I've also reduced the code to see the conduct the connection. All I can say
is the shorter the codes the more STABLE it gets. At about 1000 lines I can
say that I have 90% stability instead of 50%.

Does anyone have a clue on going arround this memory leak?

We run Win98SE to Win XPpro with Office97 to Office XP all with latast
up-dates.

Regards,

Michel


 
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
XL 2007 - Out of Memory - memory leak/bug? PCLIVE Excel Discussion (Misc queries) 0 March 23rd 09 03:31 PM
Memory Leak in Excel ofra Excel Discussion (Misc queries) 0 August 28th 05 02:20 PM
Memory leak query Blue Aardvark Excel Discussion (Misc queries) 3 July 27th 05 09:01 AM
Memory Leak GSS[_2_] Excel Programming 1 December 22nd 03 09:21 PM
Memory Leak using ADO 2.6 Jason[_17_] Excel Programming 2 August 26th 03 02:42 PM


All times are GMT +1. The time now is 03:51 AM.

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

About Us

"It's about Microsoft Excel"