Hi all,

I have a requirement to check if an object (can be any format -.docx, .pdf, etc) has been embedded to a spreadsheet.
The code I have will embed the file to cell P7 as the location.

There is a 'Check Document' Sub that checks if certain criteria have been completed (e.g. specific cells) in the spreadsheet before uploading to our SharePoint, if not all criteria is satisfied, it will exit the Sub and not post to SP, with a message box advising the user what is missing.
The code I use to check if cells are populated or not is (should noted that there is another bit of code to create the message box):

EInv = Worksheets("Registration Form").Range("E101").Value
    If IsEmpty(EInv) Then
        str = str + "Please complete 'E-Invoicing fields'" & vbCrLf
    End If
I have searched these forums and google but haven't been able to determine how (or if its possible) to check if a file is embedded at cell P7.

2 Questions

1st - How can I check if a file (Object) is located in cell P7?
2nd - Can I amend the above code to so that it will exit the sub if an object is not in the nominated cell?

Hoping someone can help me with this.
Thank you in advance,
Chris