Is there a macro to print to pdf using excel mac (Microsoft 365)?

[tonywatsonhelp]

Hi Everyone,
not sure if this can be done but I'm look for a macro to turn Sheet"Report" into a pdf and name it the name value in D4.
i need it to work on a mac and pc (or just mac)

please help if you can

Thanks

Tony

 

[DanteAmor]

Try this:

Sub Macro2()
  Dim sName As String
  sName = ThisWorkbook.Path & "\" & Sheets("Report").Range("D4").Value & ".pdf"
  Sheets("Report").ExportAsFixedFormat xlTypePDF, sName, 0, True, False, , , False
End Sub

If you have problems, you could make a macro recording, save the sheet as pdf, stop the macro, the generated code paste it here to adapt the name.

 

[RoryA]

You should use Application.Pathseparator rather than "\"

 

[tonywatsonhelp]

Thanks guys but I've tried my pc version but it debugs out.
was wounding if anyone knew how to get a mac to do it but I'll play around with it for a while.
thanks
Tony

 

[RoryA]

but it debugs out

Unless you tell us how, that's like telling a mechanic that your car "doesn't work".