Thread: Memory Leak
View Single Post
  #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