Just a quick Hello

[MarkGannon]

Dipping my toes into the excel waters and i have found then to be both very alluring and so frustrating all at the same time.
I am a teacher and finding more and more of my time is taken up with box ticking rather than teaching or lesson planning. To help with this workload issue i have been making a workbook that helps compile grades into a rubric. Things have been going well thanks to the help of a work colleague and if this is as good as it gets i am very happy. There is something's that would make it perfect however i am stuck and too inexperienced to understand what i am doing wrong.
I am Using Microsoft Excel for Mac Version 15.22.
When i try and make a macro to save the current work sheet as a PDF with the name that is taken from cell H4 on that sheet i just keep getting errors and when i do it manually it changes from landscape to portrait. To stop that change i have to go through the process of page setup and then save as PDF.
I am so out of my depth in this i dont even know what questions i need to ask about how to do it.
Hope your days are sunny.
Mark

[arlu1201]

Hello MarkGannon,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

[MarkGannon]

So this is the the beginning.


Sub SavePDF()
'
' SavePDF Macro
'

'

ActiveWorkbook.SaveAsFixedFileFormat Type:=xlPDF, Filename:= _
Range("H4").Text, FileFormat _
:=xlPDF, PublishOption:=xlSheet
End Sub


I am trying to save a worksheet as a pdf. i am wanting the file name taken from the worksheet and for the saver to choose the destination.
on Mac excel version15.22
can anyone give me some ideas as to where to start.