how to save entire excel workbook as pdf for excel 2011 on mac

Save Entire Excel Workbook As For Excel 2011 On Code Most Closely

Save Entire Excel Workbook As For Excel 2011 On Code Most Closely

I have searched the forums and the code most closely resembling what I need is this one: code Sub Saveaspdf() Dim FSO As Object Dim s(1) As String Dim sNewFilePath As String Set FSO CreateObject(Scripting.FileSystemObject) s(0) ThisWorkbook.FullName If FSO.FileExists(s(0)) Then Change Excel Extension to PDF extension in FilePath s(1) FSO.GetExtensionName(s(0)) If s(1) Then s(1).

End If Set FSO Nothing End Sub code However, this code only seems to save the active worksheet to pdf, not the entire workbook.

Furthermore, it saves it in the same location as the Excel, whereas I need the pdf saved to the Desktop.

When running your suggested code I get the error message: Run-time error 1004: Document not saved.

The document may be open, or an error may have been encountered when saving.

If I change it to my actual profile name in Windows then it works.

However this macro will be run on many different computers, so the generic term for user is required.

The FilePath should return the Desktop Path your current Workbook name.pdf regardless of which user you are using, hence can be run on any computer.

The code you suggested elimsym almost works, however it only pdfs one worksheet.

Actually Im on Excel 2007 and my code seems not working with run-time error 1004, which now makes me think that my Office didnt come with pdf add-on.

By continuing to browse this site, you are agreeing to our use of cookies.

If you would like to use all features of this site, it is mandatory to enable JavaScript.

How To Save Entire Excel Workbook As Pdf For Excel 2011 On Mac