I have a monthly EXCEL report that I save as a pdf file for ease of opening during a meeting (EXCEL file large and opens very slowly). I have used the vb code shown below to save to pdf but also just save as pdf manually. Is there coding that I could enter in the code below that would save the pdf but also open the pdf at 113% vs. having the user clicking the + sign serveral times???
' Macro1 Macro
' Keyboard Shortcut: Ctrl+z
ChDir "N:\IM NSP\Joes Monthly Reports\Z Flashdrive\Holding"
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"N:\IM NSP\Joes Monthly Reports\Z Flashdrive\Holding\10c - CA Supplier Opportunity Variance Report_XXX.2014.pdf" _
, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, From:=1, To:=2, OpenAfterPublish:=True