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
|