Saving as a PDF using VBA

[wilsond264]

Hello , I'm new to the forum. I have been trying to learn to write macros for the past few several weeks now, I have been working on a invoice form that I have created. I am trying to set up a macro that will allow me to save my document to a folder on my hard drive as a PDF. I am not able to save, I keep getting an error message, not sure what I'm doing wrong. here is a screen shot of the macro and error message. I would appreciate any help. I am running Office 2016 on a Mac. Thanks

 

[shg]

Option Explicit

Sub Save_Click()
  ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Range("H7").Value & ".pdf"
End Sub

 

[wilsond264]

Option Explicit

Sub Save_Click()
  ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Range("H7").Value & ".pdf"
End Sub

Thanks.

 

[shg]

You're welcome.