Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programmatically detect a syntax error in a macro?
I'm working on forensice sofware, using vb6, that opens Excel spreadsheets
and generates images of all possible combinations of available data. This means that one thing we have to do is run the available macros. The problem is that if we encounter a macro that contains a syntax error the Excel VBA window opens up and processing doesn't return to our application until the syntax error is resolved. We would prefer just to note that the particular macro contains an error and we will just bypass it. Is there a way to detect syntax errors without having Excel open anything up? Thanks, Jeff Beem |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programmatically detect a syntax error in a macro?
Nothing that I know of. The error handling in VB6 and VBA is a little cheesy.
Errors are not pushed up the stack, they die with the procedure. If you can move to vb.net you might be able to resolve this as it uses more classical error handling. "Jeff Beem" wrote: I'm working on forensice sofware, using vb6, that opens Excel spreadsheets and generates images of all possible combinations of available data. This means that one thing we have to do is run the available macros. The problem is that if we encounter a macro that contains a syntax error the Excel VBA window opens up and processing doesn't return to our application until the syntax error is resolved. We would prefer just to note that the particular macro contains an error and we will just bypass it. Is there a way to detect syntax errors without having Excel open anything up? Thanks, Jeff Beem |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to detect syntax in value | Excel Discussion (Misc queries) | |||
Syntax error while applying a formula in a macro | Excel Discussion (Misc queries) | |||
COUNTA function causing syntax error in macro... | Excel Worksheet Functions | |||
Macro syntax error when running query | Excel Programming | |||
Programmatically detect wrod-wrap? | Excel Programming |