![]() ![]() XlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _ Lien = "/Users/macbookpro/Desktop/INVOICE/" & Tipe2ĬhDir "/Users/macbookpro/Desktop/INVOICE/" & Tipe2ĪctiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ Sheets("NANTUCKET ESTIMATE").Range("M49") Sheets("Estimate summary").Range("E" & LigneIS + 1) = ![]() Sheets("Estimate summary").Range("D" & LigneIS + 1) = ![]() Sheets("Estimate summary").Range("C" & LigneIS + 1) = "NANTUCKET" Sheets("Estimate summary").Range("B" & LigneIS + 1) = Sheets("Estimate summary").Range("A" & LigneIS + 1) = Now Sheets("Invoice summary").Range("E" & LigneIS + 1) = Sheets("NANTUCKET ESTIMATE").Range("M49") Sheets("Invoice summary").Range("D" & LigneIS + 1) = Sheets("NANTUCKET ESTIMATE").Range("A12") Sheets("Invoice summary").Range("C" & LigneIS + 1) = "NANTUCKET" Sheets("Invoice summary").Range("B" & LigneIS + 1) = Sheets("NANTUCKET ESTIMATE").Range("H8") Sheets("Invoice summary").Range("A" & LigneIS + 1) = Now LigneIS = Application.CountA(Sheets("Invoice summary").Range("A:A")) If anybody can help me I will be very glad. Same code working on my Windows PC, but it doesn't work on my MAC pc.When I click the Save button, it's printing the pdf instead save it. I want to export the active sheet as a PDF file to the specific folder. I have a macro code for my Excel document. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |