However, if I delete the last '9' in the code, I get the above error. I recorded the macro and used the code generated in my code (as below). , Quality:=xlQualityMinimum, IncludeDocProperties:=True, IgnorePrintAreas _ PdfName = "Q - " & Range("F2").Value & " - " & Range("A2").Value & " - " & Range("B10").TextįullName = "/Users/" & QTGetUserNameMAC & "/Google Drive/ABC Pte Ltd/Q - Quotations/" _ĪctiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=FullName _ IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _ĭim pdfName As String, FullName As String ThisWorkbook.Path & PS & pdfName, Quality:=xlQualityStandard, _ WksSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:= _ If InStr(1, Application.OperatingSystem, "Windows") > 0 Then My code, which worked yesterday: 'a) For Windows "Run-time error '1004': Application-defined or object-defined error". My Excel VBA on Mac OS to save as PDF sometimes doesn't work.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |