Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 387
  • Last Modified:

Save excel file as pdf - BUT open at 113%

Hello -

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???


Sub Macro1()
' 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

End Sub
1 Solution
Randy PooleCommented:
Just Add a line ActiveWindow.Zoom=113

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now