I had this question after viewing Excel VBA To Print range To PDF And Save Using Name In Cell
I am attempting to set up a macro for my employer to automatically save a sheet print area as a PDF that gets its name from a cell on the sheet. I have attempted to use the code from the above link as well as the code below but cannot get either to work. I am a novice with VBA and am unsure of what I need to change to correct the code.
ormat Type:=xlTypePDF, Filename:= _
op:" & Range("E10").Value, Quality:= _
, IgnorePrintAreas:=False, _
I am running Excel for Mac 2011 version 14.5.5
For the purposes of this request, I am trying to save to a folder in Documents called Invoices,
My account user name is LakeBarrine, and
The cell with the data I want recorded as the PDF document name is cell E10.