application.workbooks.open False Error
I am prompting the user to select a report to open in excel. However if the user cancels the VB open prompt window then runtime error 1004. False.xls could not be found. How do i stop this from showing so when the user clicks cancel then it just exits the sub?
Please Login or Register to view this content.
Last edited by jordan2322; 01-16-2012 at 07:21 PM.
hi, try this one and see if it helps you!
Please Login or Register to view this content.
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
Thank you John55, works perfect
you're welcome! glad it helped you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks