Mac VBA Save to PDF

[bravia]

Hi all,

I'd been having great success in Office 365 the latest build running on Mac OS Catalina, (after granting permission) exporting PDFs by VBA using the following simple script.

Sub exportPatch()

lr = Sheets("1.Patch").Range("A6000").End(xlUp).Row

 s = Worksheets("Setup").Range("C53")
    
Sheets("1.Patch").Range("A1:L" & lr).ExportAsFixedFormat Type:=xlTypePDF, FileName:=s, Quality:= _
  xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
  OpenAfterPublish:=False
End Sub

Now when I run the script it initiates with a dialog showing the correct number of pages exporting - however it sends it directly to the printer, and adds it to the default printer queue, despite having a path & filename to write to - which had been working for the last few days.

I use another VBA script to create 5 new sub directories within the root directory the excel file is saved in and that works as expected still - so I'm not sure if it is a permissions issue.

I realise VBA on Mac is hit & miss, but I was achieving the result I wanted every time for a number of days & nothing has changed since, I wonder if anyone can offer and suggestions? Perhaps another PDF writing script that doesn't use the printing infrastructure?

Thanks for reading!

 

[Ron de Bruin]

Try the code on this page : PDF | Mac Excel Automation