Please help on error opening files vba

[roberttaekim]

Hi everyone. Hoping someone can help. I have this code which opens a file on the network and copy and pastes the content to a sheet and then opens the next file and copy and pastes to another sheet. How do i put some kind of on error resume so that if the first file cannot open because it is not available it just keeps going on to the next part of the code to open the next file and copy paste?

Really appreciate the help

Dim NmStr As String
NmStr = ActiveWorkbook.Name
Windows(NmStr).Activate

Report = Sheets("Documentation").Range("C5").Value
Workbooks.Open Filename:=Report
ActiveSheet.Cells.Copy
Windows(NmStr).Activate
Sheets("BS").Select
Range("A1").Select
ActiveSheet.Paste

Report = Sheets("Documentation").Range("C6").Value
Workbooks.Open Filename:=Report
ActiveSheet.Cells.Copy
Windows(NmStr).Activate
Sheets("IS").Select
Range("A1").Select
ActiveSheet.Paste

 

[Saurabhj]

Use on Error Resume Next in the beginning of code.

On Error Resume Next
Dim NmStr As String
NmStr = ActiveWorkbook.Name
Windows(NmStr).Activate

Report = Sheets("Documentation").Range("C5").Value
Workbooks.Open Filename:=Report
ActiveSheet.Cells.Copy
Windows(NmStr).Activate
Sheets("BS").Select
Range("A1").Select
ActiveSheet.Paste

Report = Sheets("Documentation").Range("C6").Value
Workbooks.Open Filename:=Report
ActiveSheet.Cells.Copy
Windows(NmStr).Activate
Sheets("IS").Select
Range("A1").Select
ActiveSheet.Paste

 

[roberttaekim]

If the file is not there i get an error saying cannot find file. I would like for it jus to skip that code and then move to the next code that opens the file and copy/pastes it. Can that be done?

 

[Saurabhj]

1. Use On Error resume next before code where you are opening the file.

2. If required you can check whether file exists or not using below code. use file name with path inside Dir function.

If Dir("path\filename.xlsm") = vbNullString Then
        MsgBox "File not exists"
else
     'Use your code
    End If

3. Share the code where you are opening the file, error you are getting and on which line of code.