Hi
I need a smiliar vbs but with Sub, not function which able to update the status on Col J when i activate the macro.
It will left a remarks
Directory & Link Ok
File was not found in folder
The best if can differentiate which one is Folder, which is link
<tbody>
</tbody>
I need a smiliar vbs but with Sub, not function which able to update the status on Col J when i activate the macro.
It will left a remarks
Directory & Link Ok
File was not found in folder
The best if can differentiate which one is Folder, which is link
H | I | J |
FOLDER Path | SINGLE Path | Status |
C:\Users\ABC\Desktop\SavedFolder\Email1\test.JPG | Link Ok | |
C:\Users\ABC\Desktop\SavedFolder\Email2\ | Folder was not found |
<tbody>
</tbody>
Code:
Function FileExist(path As String) As Boolean
If Dir(path) <> vbNullString Then FileExist = True
End Function