Run Time error '-2147024773 (8007007b)':

Hi all,

I'm seeing a similar issue as thread 1213055-excel-run-time-error-2147024773-8007007b-and-beforeprint-event but I haven't been able to figure out why I'm seeing the error.

I have a button in which I'd like to save the sheet as a PDF with a specific naming convention as determined by cell B35.
This sheet will be distributed to other users and will run from their local drive if that matters.

Sub SavePDF()
'
' SavePDF Macro
' Saves PDF to Public drive, opens PDF viewer
'

'
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
        "C:\Users\Public\Documents\" & Sheets("Record of Qualification").Range("B35").Value _
        , Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
        :=False, OpenAfterPublish:=True
End Sub

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer


The formula in B35 is as follows :

=CONCAT(C3," - ",C5," - ",(TEXT(F33,"yyyy-mm-dd")))


Thank you in advance for your help! Such a great community we have here.

Hello, I'll try to attach my file.
B35 is showing up as intended. The data from that field is supposed to be the file name for the PDF that opens.

The data showing in the B35 cell looks like this :
GRIFFIN, ROBERT - << EXAMPLE - RECEIVING >> - 2020-12-17