unknown runtime error

[vbnov]

Hi guys

I am trying to create an excel sheet with values resulting from a query from a vbscript app. when there are hundreds of rows involved its giving a runtime error. any ideas on how to fix it. help would be greatly appreciated.

[PeejAvery]

There are many runtime errors. We need to know what it says to be able to help.

[vbnov]

When i ran it on another machine it says unknown runtime error (some number)vbscript.dll.I dont know what the exact error code is. I might be able to post it later. Thanks.

[Dr. Script]

When i ran it on another machine it says unknown runtime error (some number)vbscript.dll.I dont know what the exact error code is. I might be able to post it later. Thanks.
Without the number, the line of code it is on, etc ... there is no way we can help you debug the code.

[vbnov]

Hey guys

I'm trying to create a spreadsheet. The values result from a sql. It ranges from 100 to 1100. If it retrieves less than 100 or 200 rows it works fine. but with rows greater than 250 or so it gives me an error message. The message is

"An error occured executing active script (form name). unknown runtime error (line number), (char number)"

when i click ok to this message it pops up VS.Net debugger. There are 3 options. Break, continue and help

Break - stops the execution at (for eg.)

"With objExcel.WorkSheets(i+1).Cells(intRow, intCol+1)
.Value = objBuy("TRY") "

places where it tries to write the value in the spreadsheet

Continue - it keeps on writing the rest of the rows with or without more runtime errors.

Help - Microsoft visual studio Debugger (exception thrown) dialog box.

As i read thru it i came to know the following

In VC ++

Stack pointer corruption.
Overruns of local arrays.
Stack corruption.
Dependencies on uninitialized local variables.
Loss of data on an assignment to a shorter variable.

So I'm guessing may be one of the above is causing the runtime error. And I am using VBScript . Any ideas on how to handle this unknown exception.

Help gurus.

Thanks

[PeejAvery]

Is this still the same problem as your last runtime error thread. Please do not create new threads for the same problem.

Dr. Script, could you please merge these if the above is the case?

[Dr. Script]

Done.