+ Reply to Thread
Results 1 to 4 of 4

Question -> Save portion of worksheet in PDF & Email out

  1. #1
    Registered User
    Join Date
    06-11-2014
    Posts
    15

    Question -> Save portion of worksheet in PDF & Email out

    Hi:
    I have the following code in VB from somewhere. Is anyone can help me solve two questions that I am not sure how to modify or adding from the following codes.

    (1) Is anyway I can modify sedning out PDF instead of the actual workbook?
    (2) Is anyway I just want the range from (A1:G80) instead of the whole sheet for printing (PDF)

    If you could help me modify from the following, I am very appreciate!


    Please Login or Register  to view this content.
    Last edited by Leith Ross; 06-26-2014 at 03:01 PM. Reason: Added Code Tags

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Question -> Save portion of worksheet in PDF & Email out

    1) Is anyway I can modify sedning out PDF instead of the actual workbook?
    yes. save it as pdf but before select the range to "print" as in question #2 and mark it as the desired range in page layout
    (2) Is anyway I just want the range from (A1:G80) instead of the whole sheet for printing (PDF)
    see explanation above

  3. #3
    Registered User
    Join Date
    06-11-2014
    Posts
    15

    Re: Question -> Save portion of worksheet in PDF & Email out

    Quote Originally Posted by rcm View Post
    1) Is anyway I can modify sedning out PDF instead of the actual workbook?
    yes. save it as pdf but before select the range to "print" as in question #2 and mark it as the desired range in page layout
    (2) Is anyway I just want the range from (A1:G80) instead of the whole sheet for printing (PDF)
    see explanation above
    HI rcm:
    Thanks for your reply. The above code is working without any error. But this code can only attach my WHOLE workbook to MS Outlook & email it out to the right person.

    Instead of whole workbook, I just want the code can be smart enough convert my worksheet to PDF and only from range A1:G100. Then attach to outlook & sending it out.

    Sorry for confusing!!

  4. #4
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Question -> Save portion of worksheet in PDF & Email out

    Please Login or Register  to view this content.
    you could replace the section about the file extention and range

+ 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. [SOLVED] save worksheet as pdf and email it
    By wolfm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2013, 02:20 AM
  2. [SOLVED] Save active worksheet to pdf and email
    By wolfm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2013, 02:19 AM
  3. VBA to save worksheet as a pdf and email
    By menmine5 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-15-2012, 09:43 AM
  4. Save worksheet as PDF then email
    By pjxcelwizard in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-14-2011, 10:25 AM
  5. Save Worksheet from a Workbook and email
    By manny_cb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-29-2010, 08:03 PM

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