The Workbooks.open filename seen below prompts an error because it does not exist. I want a way to either check if the workbook exists and if it does then continue code and if it doesn't then skip part of the code and resume. Or I want a way to on error of trying to open workbook skip this part of code and resume at this place. I believe either one will work but i am not fimilar with the If and objects enought to know how to write it as i am self taught. If you reply with an answer and put it into the code please also list the answer outside of the code as well please in a seperate code window. Thanks.
Workbooks.Open Filename:= _
"I:\ACCOUNTING\Clear Payments\2013\2013-01\Completed\DATE6_GA_LocationSummaryReport.xls"
Columns("A:A").Select
Bookmarks