![]() I've got a macro on Excel 2016 which works great to create PDF. But this macro only works for Excel 2016 for Windows. I try it on Excel 2016 (last version) for Mac and it doesn't work. Here is my macro Sub Macro1() Dim Chemin As String Dim texte As String Chemin = ThisWorkbook.Path & '/' texte = Range('C3') Application.DisplayAlerts = False ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _ Filename:=Chemin & texte & '.pdf', _ Quality:=xlQualityMinimum, _ IncludeDocProperties:=True, _ IgnorePrintAreas:=False, _ OpenAfterPublish:=False Cells(1, 3).Value = Cells(1, 3).Value + 1 End Sub I made lots of searches and it seems that the 'ExportAsFixedFormat Type:=xlTypePDF' doesn't work on the last Excel version for Mac. Free online iso file for mac os x. Free downloads microsoft word for mac. But I can't find any other way. Aug 7, 2017 - First, open the Macro editor in Word (both the Windows and OSX versions will work for this). The Macro editor is accessed by enabling the.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2019
Categories |