![Mac pages save as pdf Mac pages save as pdf](https://officesnapshots.com/wp-content/uploads/2013/04/gsk-navy-yard-grand-stair-700x463.jpg)
Hello!
I have been trying to find the VBA code for the Mac as it is working well on Windows. Here is the VBA code for Windows:
Sub SaveAsPDF()
Dim strDesktop As String
strDesktop = CreateObject('WScript.Shell').<wbr>SpecialFolders('Desktop')
ThisWorkbook.<wbr>ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=strDesktop & 'invoice ' & Format(Date, 'mm.dd.yyyy') & '.pdf'
Range('F3').Value = Range('F3').Value + 1
Range('E14:J24').ClearContents
End Sub
This code will save the entire worksheet, I did change ThisWorksbook to ThisActivesheet, but it did not work as I only want to save one active sheet called 'Invoice,' not the entire worksheet. I would like to know how to save as the PDF on Mac? I also would like to see if it is possible for me to type a filename manually after before I save the PDF. Is it possible to save it under Documents rather than on the desktop? It would be challenging to track invoices if I use to like this invoice 28.09.2018.pdf. I want to input the name company, invoice #, and date. Last, when I close the Excel and open it again, the invoice number will be saved as previous. Is there a way to increment the invoice number when opening the Excel?
Thanks in advance!
I have been trying to find the VBA code for the Mac as it is working well on Windows. Here is the VBA code for Windows:
Sub SaveAsPDF()
Dim strDesktop As String
strDesktop = CreateObject('WScript.Shell').<wbr>SpecialFolders('Desktop')
ThisWorkbook.<wbr>ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=strDesktop & 'invoice ' & Format(Date, 'mm.dd.yyyy') & '.pdf'
Range('F3').Value = Range('F3').Value + 1
Range('E14:J24').ClearContents
End Sub
This code will save the entire worksheet, I did change ThisWorksbook to ThisActivesheet, but it did not work as I only want to save one active sheet called 'Invoice,' not the entire worksheet. I would like to know how to save as the PDF on Mac? I also would like to see if it is possible for me to type a filename manually after before I save the PDF. Is it possible to save it under Documents rather than on the desktop? It would be challenging to track invoices if I use to like this invoice 28.09.2018.pdf. I want to input the name company, invoice #, and date. Last, when I close the Excel and open it again, the invoice number will be saved as previous. Is there a way to increment the invoice number when opening the Excel?
Thanks in advance!
Instead of a physical printer, you can select Adobe PDF in almost any Windows or Mac OS application. Using Print to PDF, you can create an electronic copy of your file that you can save to disk. You may be wondering why you’d want to save a webpage as a PDF for your Mac. Vuescan 9 6 44 magnum. There are actually several great reasons! Perhaps you found an article you’d like to read later, or you want to save a webpage as a PDF because you’re a designer and want to use it as inspiration for your own site.
Save As Pdf Macro Excel
I downloaded a PDF from an email, opened it in Adobe Reader Acrobat (DC), and now when I try to save it to a particular folder, cannot because when I click on the 'save as' all I get is an empty white box. I tried re-installing, but when I do the installation fails because it is already there. Excel Mac 2011 VBA will always save all worksheets. If you turn on the Macro Recorder and save a sheet to PDF, it works as expected and writes out the ActiveWorkbook version to the code module. Now immediately re-run that very code that it generated and it yields a different result! Here are some PDF/A, and PDF/X output solutions for macOS Sierra: LibreOffice Writer. Export to PDF provides PDF/A-1a option; Does not use Apple PDFKit; Serif Labs Affinity Designer (Mac App Store, free trial) Open existing single, or multipage PDF, edit, and export as: PDF/X-1a; PDF/X-3; PDF/X-4; Crop, bleed, registration marks, and color bar.