Computing.net: Question & Answers Forum Latest Questions

computing
  • 58
  • 58

I am looking for a macro that when I click on a button, the workbook is saved as a PDF file and automatically named based on cell content. Excel 2007 Sub pdfsave() pdfname = Range(“A1”).Value ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=pdfname, Quality:=xlQualityStandard, _IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= ...