+ Reply to Thread
Results 1 to 2 of 2

Mac office, print area save as PDF, name PDF by cell value

  1. #1
    Registered User
    Join Date
    09-14-2011
    Location
    London
    MS-Off Ver
    Mac Office 2011
    Posts
    62

    Mac office, print area save as PDF, name PDF by cell value

    I'm using mac office and I recorded this macro.
    I use it to select the area and then print but select the save as PDF.

    What I can't see in this code is where does it save it to??
    And how can I save it by the value of D2 as its file name?

    Many Thanks

    Matt

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    09-14-2011
    Location
    London
    MS-Off Ver
    Mac Office 2011
    Posts
    62

    Re: Mac office, print area save as PDF, name PDF by cell value

    I found this http://www.ozgrid.com/forum/showthread.php?t=169852

    and this seams to help

    Please Login or Register  to view this content.
    Having said that it cuts off the edge of the frame, need to make it fit the page somehow
    Last edited by thequiff; 10-25-2013 at 01:48 PM.

+ 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. Print area and save to pdf
    By saniamarco in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-28-2013, 05:39 PM
  2. Replies: 1
    Last Post: 02-12-2013, 12:16 PM
  3. Loop, Save Print Area as Published Webpage to Folder
    By mh104916 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-19-2012, 01:32 PM
  4. Replies: 8
    Last Post: 05-23-2007, 06:39 AM
  5. [SOLVED] 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

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