Run-time error '1004': Method 'ExportAsFixedFormat' of object '_Worksheet' failed

Hello, looking for some help on exporting a sheet to a PDF. Using Excel for MAC 2016. this is driving me crazy. Everywhere i search the same syntax is used, yet not for me.

the macro runs, initially i get a "Save" box telling me it is preparing
then a print error box,
once i hit OK I get
Run-time error '1004':

Method 'ExportAsFixedFormat' of object '_Worksheet' failed

Sub PDF()
Dim wksheet As Worksheet
Dim filename As String

Set wksheet = ThisWorkbook.Sheets("Calculator")

filename = ActiveWorkbook.Path & "temppdf.pdf"

With wksheet
.PageSetup.PrintArea = Range("A1", "N46").Address
End With

wksheet.ExportAsFixedFormat _
Type:=xlTypePDF, _
filename:=filename, _
quality:=xlQualityStandard, _
includedocproperties:=True

End Sub

Thank you CK76. Provided fix and still same issue???

At least it works some place. Im running it on a MacBook Air, OS X El Capitan V.10.11.6.

Do you think this could be the problem???

Thank you

I don't think so.

Only other problem that I can think of is... if the Activeworkbook is on Network shared drive, and when you don't have appropriate permission to save files.

for some reason it does not like the ExportAsFixedFormat command. Any others that I could use?

Thank you

Hmm, from what I can find, Excel 2016 on Mac has few bugs (my colleague's Mac has Excel 2011).

Try going through Ron de Bruin's site. His site is one of the best resources on Mac VBA.
Link below is for saving PDF on Mac (works for Excel 2016).
https://www.rondebruin.nl/mac/mac005.htm

Thank you for all your help. Ill post fix if i can figure out whats wrong