Help with VBA Error Handling

[jo15765]

I have never done any error handling, I would always just let the code crash, and pick up the pieces after the fact. Well this time I am going to try to add error handling, and what my thoughts are is to have the code say on error jump to the next and then show a log at the end of what failed. For example..

Workbooks.Open Filename:="C:\JJones\Daily\Daily.xls"
With Sheets(Array("Today", "Yesterday")).Select

And of course some of the array's are more complex and that is just a snippet. I was thinking something along the lines of if Today doesn't exist or a problem opening that, then proceed to Yesterday and then show me a log at the end of what the error(s) are.

Is that a feasible mindset or am I way out in left field? Also, how difficult would that be to code?

 

[GTO]

Hi Mark,

Yes, I was but a combination of babies and spreadsheet glare has aged me terribly!

Goodness, and I was suspecting moderator responsibilities after seeing Richard's updated pic!

Well if you see this, I'd much rather admit ignorance than stay that way... Who actually is the (presumably) mathematician?

As always, Cheers and best regards,

Mark

 

[RoryA]

It's "the old man" by Rubens actually - related to my former tagline as "Old Father Time" or something similar (more of Richard's cheek, which is actually what got him into his current position. )

 

[GTO]

Ahh! Well I don't feel too bad then , I was halfway guessing at da Vinci. Still too bad about Richard. I always thought he looked very comfortable plopped on the couch with his girls. The later condition, well....

Yack at you later and a great day to your and yours,

Mark