Prev: Use Macro to Select printer in Word 2007 on Windows 7 Pro
Next: Simple hack to get $500 to your home.
From: Clinton M James on 30 Jun 2010 09:19
I wish to use vbscript to automate macros running over many workbooks.

I will allow a number to run at any given time, therefore i need to use
vbscript to detect if a macro has ended. This is not posing an issue. The
issue I foresee is if the macro being run in the excel book decides to error
(maybe because an SQL server is down, or any reason really)... I need the
ability to have vbscript work out that the runtime error has occurred in the
excel workbook, kill the application, then re-launch the workbook to allow
the maco a second run.

Essentially, how will i use vbscript to detect errors occuring within excel?

Help is appreciated and I thank you in advance.

Cheers.
Clint

 | 
Pages: 1
Prev: Use Macro to Select printer in Word 2007 on Windows 7 Pro
Next: Simple hack to get $500 to your home.