Hi Friends,

I am a new visitor to this forum and looking forward for some help!!

I am looking for a vba code which would open multiple files on a specific folder. The directory and path is listed on a sheet. The code also needs to move on to the find the next sheet if the current ones are missing from the folder.

To provide the details:

File name 1
File name 2
File name 3
File name 4
File name 5

Path is provided at - Sheets("Sheet1").Range("B3")
File names are provided from range - Sheets("Sheet1").Range("D3") to Sheets("Sheet1").Range("D8")I did try starting off with a code like below:


If Dir(Sheets("Sheet1").Range("B3").Value & Sheets("Sheet1").Range("C3").Value & "_" & Sheets("Sheet1").Range("D3").Value) = vbNullString Then

Workbooks.Open Filename:=Sheets("Sheet1").Range("B3").Value & Sheets("Sheet1").Range("C4").Value & "_" & Sheets("Sheet1").Range("D4").Value, UpdateLinks:=0


Else

Workbooks.Open Filename:=Sheets("Sheet1").Range("B3").Value & Sheets("Sheet1").Range("C3").Value & "_" & Sheets("Sheet1").Range("D3").Value, UpdateLinks:=0

Call Paste

End If


But the error popped up as filename on cell D3 & D4, both were missing. Thanks for all your help in advance.!
Regards
N