Save excel worksheet to pdf and use cell to name the file
Posted on 2014-01-07
I am attempting to write a macro to save a worksheet to PDF and name it based on a cell value, however I am getting an "expected end of statement error with my code.
' savePDF Macro
Dim fname As String
fname = .Range("f5").Value
.ExportAsFixedFormat Type:=xlTypePDF, FileName:= _
"C:\Users\IJ64770\Desktop\"& fName", Quality:= _
xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
Any suggestinos as to where I am going wrong?