+ Reply to Thread
Results 1 to 6 of 6

convert excel sheet to pdf using macro and send that pdf via email using outlook

  1. #1
    Registered User
    Join Date
    04-19-2012
    Location
    vizag
    MS-Off Ver
    Excel 2007
    Posts
    31

    Post convert excel sheet to pdf using macro and send that pdf via email using outlook

    hi frnds,


    i am new to excel coding...

    my doubt is

    1) how to convert excel sheet to pdf using macro
    2) if User selects macro within “sheet1” to send internal PDF copy via email using Outlook, and saves PDF to default directory

    Thanks & regards
    u r frnd..

  2. #2
    Forum Expert
    Join Date
    03-13-2004
    Location
    Gothenburg/Stockholm, Sweden
    MS-Off Ver
    Excel 2003, Excel 2007 & reluctant Excel 2010 user
    Posts
    4,526

    Re: convert excel sheet to pdf using macro and send that pdf via email using outlook

    If you whish to save part of a worksheet as a pdf file you could try something like this:

    Please Login or Register  to view this content.
    where "C\Temp\" is the folder to where the pdf file will be saved and Range("A1:I48") is the part of the active worksheet that will be saved.

    To save all of a sheet make it first active and start with the command
    Please Login or Register  to view this content.
    You also need to have "2007 Microsoft Office Add-in: Microsoft Save as PDF" installed.

    http://www.microsoft.com/en-us/downl...s.aspx?id=9943


    Alf

  3. #3
    Registered User
    Join Date
    08-04-2012
    Location
    Bangkok, Thailand
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: convert excel sheet to pdf using macro and send that pdf via email using outlook

    I have a similar circumstance.

    I would like to save an inactive worksheet to a .pdf in a folder on my computer.

    How would I do this? I am new to macros and not proficient at macro code/VB jargon. Sorry...

    Thanks for any help you can be.

    Mark

  4. #4
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,157

    Re: convert excel sheet to pdf using macro and send that pdf via email using outlook

    Mark,

    Welcome to the Forum, unfortunately:

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  5. #5
    Registered User
    Join Date
    10-22-2012
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: convert excel sheet to pdf using macro and send that pdf via email using outlook

    Hello,

    I am also trying the same thing. This code doesn't work...it says that "file did not save". What did I miss.

  6. #6
    Forum Expert
    Join Date
    03-13-2004
    Location
    Gothenburg/Stockholm, Sweden
    MS-Off Ver
    Excel 2003, Excel 2007 & reluctant Excel 2010 user
    Posts
    4,526

    Re: convert excel sheet to pdf using macro and send that pdf via email using outlook

    An old thread but perhaps a bit more information is needed. A macro like this will save a specified range of the active worksheet (range A1:J13) with the name of "Tester.pdf" to the folder "C:\Temp\"

    Please Login or Register  to view this content.
    Or you could also it this like this:

    Please Login or Register  to view this content.
    This will copy the specified range, add a workbook and copy the specified range to this book and save the added workbook as "Book2.pdf" to folder "C:\Temp\".

    Remember you can only save the active sheet or parts of it as a pdf file. If you wish to save the whole workbook containing 2 or more sheets you need to buy/find 3de party converters.



    Alf

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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