Error handling

[Springy]

I have a vbscript that opens excel and does a whole load of stuff. If the excel or the VB script fail I want the vbscript to exit via an error handler.

How do I do this??


Thanks

Tim

 

[culshaja]

You need to use the

on error goto (label)

statement. When an error occurs the code will then branch to the code after the label.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[dtqui]

James,

could you elaborate on the on error goto part because I tried it but it does not work. Thks.

 

[jaredn]

don't know if that works, think you have to use in

on error resume next

for vbscript jared@aauser.com

 

[culshaja]

If you use

On Error Resume Next

in VBScript you need to check for a sepcific Error Number or check after where you think an error will occur to handle the error. This type of error handling is very good for handling ADO connection failures.

I'm sure that the label method will work though. Maybe I'm just confused with using it in VB all the tiome though.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305