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.
Subscribe to our Windows Secrets Newsletter - It's Free!
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!