Search a file and open from Folder

[Muthu_1436]

Hi All,

I have list of ID's in excel. In folder there are file which has this ID's. I need to search the folder with this name and open the file.
Can you help me in creating macro for this.


I receive error if one particula ID's is not available in the folder. I want that id to be skipped and open for the nex ID

Workbooks.Open Filename:=pathx & "\" & DateX & "\" & ACNIDX & "_" & DateX & ".xlsb"

 

[Comfy]

You can use the DIR() function to find ou if the file exists:

If[FONT=Consolas, Courier New, Courier, mono] Len(Dir([/FONT]pathx & "\" & DateX & "\" & ACNIDX & "_" & DateX & ".xlsb")) > 0 Then
Workbooks.Open Filename:=pathx & "\" & DateX & "\" & ACNIDX & "_" & DateX & ".xlsb"[FONT=Consolas, Courier New, Courier, mono]
'Followed by your remaining code
End if

[/FONT]

 

[Muthu_1436]

Great and bunch of thanks Comfy this works for me.