+ Reply to Thread
Results 1 to 5 of 5

Save to PDF with defined name for print/save area

  1. #1
    Registered User
    Join Date
    05-31-2018
    Location
    Traralgon, Australia
    MS-Off Ver
    2013
    Posts
    5

    Save to PDF with defined name for print/save area

    Hi Guys,

    I'm trying to automate a save to PDF process that attaches to email.
    I've managed to get it all working except after some revision requests I've had to change the margin & print principles.

    Please Login or Register  to view this content.
    The above code works perfectly for the initial revision.
    Now I need to have it save either to a defined name I've created or based on my custom scaling it is a zoom of 72%.
    All attempts to modify the code above have resulted in epic fail on my part.

    Can anyone point me in the right direction?
    I've attached a copy of the file if this helps also.

    Thanks in advance guys

    Austie
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Save to PDF with defined name for print/save area

    Try this
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Registered User
    Join Date
    05-31-2018
    Location
    Traralgon, Australia
    MS-Off Ver
    2013
    Posts
    5

    Re: Save to PDF with defined name for print/save area

    Hi YasserKhalil,

    Unfortunately that didn't resolve my problem as it is not scaling to the desired level and you code has changed the pdf file name resulting in the open to email section falling over.

    I have been trying to get the .zoom working as it needs to be set to 72% but without any success.
    Instead of saving to PDF would a print to PDF be more viable?

    Regards

    Austie

  4. #4
    Registered User
    Join Date
    05-31-2018
    Location
    Traralgon, Australia
    MS-Off Ver
    2013
    Posts
    5

    Re: Save to PDF with defined name for print/save area

    Hi YasserKhalil,

    I found the solution by pure fluke by adding this before the PDF section

    Please Login or Register  to view this content.
    So now the competed code looks like this"
    Please Login or Register  to view this content.
    Your code did get me trying to find other alternatives so thanks for the heads up YasserKhalil.

    Regards

    Austie

  5. #5
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Save to PDF with defined name for print/save area

    You're welcome Austie. Glad you can find the solution
    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Set print area and save as pdf
    By Jean-Felix in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-11-2018, 02:05 AM
  2. Macro, to Set Print Area, Save as, Print
    By paul0872829332 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-29-2015, 04:57 AM
  3. A way to save 'set print area' views?
    By Curious Dude in forum Excel General
    Replies: 3
    Last Post: 06-25-2015, 01:37 AM
  4. Save set print area as PDF
    By benjuk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2015, 07:23 PM
  5. Save Print Area as PDF
    By moosmahna in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2013, 09:29 AM
  6. Print area and save to pdf
    By saniamarco in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-28-2013, 05:39 PM
  7. How do I get excel 98 to save my set print area?
    By jlpdesign in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-18-2005, 10:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1