Hi guys,
I have an Excel list of filenames together with a list of respective subfolder paths (in a particular folder). I just want a VBA code to check if a file exists in its respective subfolder or not.
The Excel list is as follows:
Column A: Filenames (starting with A2); for example, abc.xml
Column C: subfolder paths (starting with C2); for example, C:\Testing\ABC\123_ABC, C:\Testing\ABC\345_ABC, ect.
In the case of no files are found in a subfolder, the column D will show a text "Not Found" or something.
Please help me with this issue.
I have an Excel list of filenames together with a list of respective subfolder paths (in a particular folder). I just want a VBA code to check if a file exists in its respective subfolder or not.
The Excel list is as follows:
Column A: Filenames (starting with A2); for example, abc.xml
Column C: subfolder paths (starting with C2); for example, C:\Testing\ABC\123_ABC, C:\Testing\ABC\345_ABC, ect.
In the case of no files are found in a subfolder, the column D will show a text "Not Found" or something.
Please help me with this issue.