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('NANTUCKET ESTIMATE').Range('A12') 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. Now go to your favorite webpage and hold down the command key and press “P” twice.I have a macro code for my Excel document. Just do it.įor the keyboard shortcut use: command + P (I know this sounds like a conflict with the print shortcut, but trust me) Type in the Command exactly as it appears: “Save as PDF…” For the ellipses, use the combination: option + semicolon. Then a box pops up asking for the command. Open your Keyboard Shortcuts tab in the Keyboard & Mouse system preference pane.Ĭlick the “+” sign to add a new shortcut for all applications. That address this very problem very easily through with a keyboard shorcut.

So I’ve been thinking about this and wondering if there is an Automator action or perhaps an Applescript that can simplify this. Granted this is probably less than 10 seconds but I do it a lot and it makes me just a little bit nuts. Each step requires me to get the mouse in the right place and read the menu. The problem is that in order to do so you must click print, then the PDF button, then the “Save as PDF” button. Whether it is a utility bill or legal research, I have a fetish for saving PDF copies.

I constantly find myself saving from Safari to PDF. Here is one thing that has been driving me crazy for some time.

This post was updated in 2013 with a fancy screencast.

How to save a pdf on mac