error trapping

[JohnE]

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

[K Dales]

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

[JohnE]

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