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.