Thread
:
Trap Word Error
View Single Post
05-07-2020, 02:17 PM
gmaxey
Windows 10
Office 2016
Expert
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,429
Put and On Error statement before you attempt to open the file e.g.,
On Error GoTo Err_Handller
Then before the End Sub Line add:
lbl_Exit:
Exit Sub
Err_Handler:
Msgbox Err.Number & " " & Err.Description
Resume lbl_Exit
__________________
Greg Maxey
Please visit my web site at
http://www.gregmaxey.com/
gmaxey
View Public Profile
Find all posts by gmaxey