Terminal Server 2003 + Excel 2000

  • Thread starter Thread starter MD
  • Start date Start date
M

MD

I log on through Terminal Server 2003 via window's remote connexion, onto an
Excel file operating on Excel 2000.

I execute a series of codes (14000 lines split into 20 subs all on two
modules).

When the codes runs for the first time (after an initial log on) I get a
message "not enough memory" and the EXCEL application shuts down. But when
I run it "X" amount of times after that, it works fine.

The problem is only on the first run!

I have a "on error resume next" and it doesn't catch the error, it just
jumps right out of EXCEL

Now if this code is executed right on the server, it works fine!!
Also, after the first run, if I opne a new workbook and try to do copy and
paste, it tells me "Clipboard can not be emptied"

Any clues anyone???
 
Without looking at the code, it could be difficult to diagnose.

Here's something to try.
In a test environment, try removing all of your code.
If it doesn't fail now, then it's a code problem.

Remove half of your code. If it fails then remove half again, and half again
etc.. until it doesn't fail.
At 14000 lines of code, you could be able to find the line within 14 splits.
 
Back
Top