error trapping
 

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

error trapping
 

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.
--
- K Dales


"JohnE" wrote:

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

error trapping
 

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


"K Dales" wrote:

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.
--
- K Dales


"JohnE" wrote:

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