I have a simple macro on an excel sheet where at the click of a button, it changes the page into a pdf.
Currently, the path is as such:
Sub savereport()
'
' savereport Macro
'
Sheets("Print Preview").Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _...