Excel 2 PDF

Question

Hi!

I need to save different Excel sheets in to the separate PDF files. Not one by one, not all in one, but each sheet with it's own name should be exported to the separate PDF file with corresponding file name. It was possible in one of the Excel releases during this year, nut now I cant see this option anymore. Thanks for advise!

Answer 1

Will something like this work on a Mac?

Sub Make_Sheet_PDF()

'produce one pdf per sheet

Dim w As Worksheet

    Application.ScreenUpdating = False

    Application.DisplayAlerts = False

    For Each w In ActiveWorkbook.Worksheets

        w.Copy

        With ActiveWorkbook

        .ExportAsFixedFormat Type:=xlTypePDF, _

             FileName:="C:\myfolder" _

                  & "" & w.Name & ".pdf"

            .Close

        End With

    Next w

    Application.DisplayAlerts = True

    Application.ScreenUpdating = True

End Sub

Gord

Answer 2

That article is of absolutely no relevance.

Please refrain from supplying Windows-based solutions to Mac users. It is, at the least, unfair to misguide them for the sake of trying to line your pockets.

Answer 3

Hello

Please review this article

https://www.gcflearnfree.org/excel2016/saving-a...

Disclaimer: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

Answer 4

OS 10.13.4 (17E202)

16.13

Thanks!

Answer 5

1. What is your Mac OS version? 10.13.4, 10.13.3....
2. What is your Office version? 16.13, 16.12, 16.11, 15.41....