Vba Code to open multiple files from a specific directory
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