Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    Busselton, Western Australia, Australia
    Posts
    59
    Thanks
    1
    Thanked 2 Times in 2 Posts

    Printing to JPG Format

    Hi All,
    I would like to output directly to JPG format from within Excel 2010. Firstly, is this possible?
    i.e. when printing, rather than output going to a printer or to a PDF file I would like a series of JPG images created, one for each page to be "printed".
    Anyone have an idea as to how I can do this?
    Not afraid of using VBA to achieve this, just no idea how to do it.
    Thanks in advance for any help.
    Regards
    Brian.

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,435
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Brian,

    I'm not aware of any utilities that allow you to "Print to JPG".
    You can however go into Print preview mode and then use the Snipping Tool in Win-7 to capture the screen and save it to a .JPG file.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts
    Not an advertisement for software, but if you install SnagIt it will drop a print location in your printer list. I haven't tried it however.


    Print.JPG
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  4. #4
    Star Lounger
    Join Date
    Apr 2002
    Location
    Busselton, Western Australia, Australia
    Posts
    59
    Thanks
    1
    Thanked 2 Times in 2 Posts
    Thanks for those suggestions, Have tried them and get a somewhat variable result as it really depends on the zoom factor etc as to what size your final output achieves.
    That is why I was hoping for some kind of other solution.
    Oh well I will keep looking I guess.
    Thanks
    Brian.

  5. #5
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    Just curious as to why you want this?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  6. #6
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    Further to RG's reply of 6 October, I was experimenting with this out of curiosity and found that this works:

    Select the area you want to have in the jpg and Copy it.

    Open your picture editor with no picture selected and just Paste. Rather to my surprise this created a jpg (or whatever default format your picture editor is set to eg bmp) straight away - which you can save or print. I tried this with several picture editors - IrfanView (free), Photoshop and PaintShop Pro - all worked.

    Going backwards then, how to get the Print Area into the Clipboard ? This line of VBA works perfectly:

    Code:
    Range(ActiveSheet.PageSetup.PrintArea).Copy
    Is that enough for you to do what you want fairly easily ?

Posting Permissions

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