error trapping

[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

 

[Guest]

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.

 

[Guest]

Thank you for the info. That just made life a bit simpler in the project.
*** John