VBA integrating FileExist() into loop before attachment.add link

Asked Oct 27 '21 at 14:45

Active Oct 27 '21 at 14:48

Viewed 32 times

current at work, I have a script where i would need help on the section involving the

Attachment.Add function in VBA

currently as the script loops

Attachment.Add link returns a runtime error message warning file doesnt exists and stalls up the script from moving forward

where link = cell(rows,44)

and cell that carries the link usually goes like this P:\test.pdf

im trying to find something similar to

If FileExist("Link") = True THEN attachment.add link end if

asked Oct 27 '21 at 14:45

Bryan Guguen

[`Dir`](https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/dir-function) or [`FileExists`](https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/fileexists-method). – BigBen Oct 27 '21 at 14:46

0 Answers0