Thread: Resume after error (2000/XP)
2006-01-19, 10:20 #1
- Join Date
- Jan 2001
- Manchester, Gtr Manchester, England
- Thanked 0 Times in 0 Posts
Resume after error (2000/XP)
I have a routine that prints(previews) 3 reports in turn (for a selected record).
The reports have Cancel=True in the Report_NoData which causes error 2501 'Open report was cancelled.'
I'm catching this in the error handler but the routine then exits - I want the code to continue running on the line after the one that caused the error.
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!