View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Priya[_4_] Priya[_4_] is offline
external usenet poster
 
Posts: 6
Default Capturing errors in Macros using VB

Hi,

I have an application written in VB which runs a particular macro in a few
Excel workbooks. Is there a way to capture the errors raised in the macro in
VB? Specifically, I dont want Excel or VBA to display any errors. All errors
must be transfered to the VB code calling the macro. (Err.Raise in the macro
just shows up a dialog with it going into the errorhandler of the calling VB
code.)

Thanks in advance!
Priya