Moving from Windows 10 to Apple MAC. Code help please

[EddyStone]

Help with macro please.

The Sub below works fine with Excel using Windows 10 however I am migrating to Excel in MAC. When I run the macro I get an Error while Printing message. If I go to DEBUG and change the path to “DATA1\DATA\DROPBOX\BUSINESS\PDF_INVOICE" I still get an error but this time the row.
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False.
Is highlighted in yellow. Not sure how to fix all help really appreciated



Sub PDFSAVE()

Dim FName As String
With ActiveSheet
FName = .Range("E13").Value & .Range("I6").Value
.ExportAsFixedFormat Type:=xlTypePDF, FileName:= _
"E:\DATA\DROPBOX\BUSINESS\PDF_INVOICE" & FName, Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False
End With
SaveSheet
End Sub

 

[EddyStone]

If anyone has any suggestions this is what I want to do on the MAC

-------


Select RangeA2 to I44
Use the filename that’s in Cell H10
Save as PDF to Path DATA1\DATA\DROPBOX\\BUSINESS\PDFINVOICE Filename as in Cell H10)