error trapping

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello. Generally I work in Access but have been asked to work on automating
a series of spreadsheets in a workbook. For the most part I have the coding
but what I was wondering about more is the error trapping. Is it the same as
what I would use in MS Access?
Thanks to anyone who responds.
*** John
 
Yes, VBA is VBA whether in Access or Excel. Only thing different is the
object model. So the On Error ... statements and the Err object are
applicable in both settings.
 
Back
Top