ChrisJRutter
Member
Hi All
Can anyone tell me how to trap an error returned from a COM object.
For example:
If "Sheet1" doesn't exist in
chSheet = chBook:Sheets:Item("Sheet1")
then we get an error dialog
If "Sheet1" doesn't exist in
chSheet = chBook:Sheets:Item("Sheet1") NO-ERROR
then we don't get the error dialog but how can we trap it?
Cheers
Can anyone tell me how to trap an error returned from a COM object.
For example:
If "Sheet1" doesn't exist in
chSheet = chBook:Sheets:Item("Sheet1")
then we get an error dialog
If "Sheet1" doesn't exist in
chSheet = chBook:Sheets:Item("Sheet1") NO-ERROR
then we don't get the error dialog but how can we trap it?
Cheers