Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Trapping | Excel Discussion (Misc queries) | |||
Trapping #VALUE! error | Excel Discussion (Misc queries) | |||
Error Trapping | Excel Programming | |||
Error Trapping | Excel Programming | |||
error trapping | Excel Programming |