Results 1 to 7 of 7
Like Tree1Likes
  • 1 Post By John_w

Converting Excel sheets to jpeg

This is a discussion on Converting Excel sheets to jpeg within the Excel Questions forums, part of the Question Forums category; Hello Guys I currently update 10 spreadsheets weekly, within each there are 5 worksheets that I convert into pictures, - ...

  1. #1
    New Member
    Join Date
    Jan 2009
    Posts
    32

    Default Converting Excel sheets to jpeg

    Hello Guys

    I currently update 10 spreadsheets weekly, within each there are 5 worksheets that I convert into pictures, - (There are more than 5 worksheets within each spreadsheet, but I only generate pictures for 5)

    I currently do this copying a range and pasting into (currently) to IrfanView, saving the image with the same name as the worksheet and moving on to next..

    This method is becoming very tedious as I generate 50 pics a week, which ultimately get uploaded to my pro-boards forum. The following week the process starts again as the old pictures are now out of date

    is there a way automating any or all of this procedure with VBA/Macro?


    The only alternative that I can think of is to uploading the whole spreadsheet to a host and embedded it into my forum, but this has been very unsuccessful as the worksheets are all linked to each other and have lots of hidden columns etc

    Thanks in advance

    Mick

  2. #2
    Board Regular
    Join Date
    Jul 2014
    Location
    Memphis, TN
    Posts
    1,612

    Default Re: Converting Excel sheets to jpeg

    Maybe you could call the MR Excel HTML Maker in a macro for your needs.

  3. #3
    Banned user
    Join Date
    May 2014
    Location
    Germany
    Posts
    1,336

    Default Re: Converting Excel sheets to jpeg

    Quote Originally Posted by SpillerBD View Post
    Maybe you could call the MR Excel HTML Maker in a macro for your needs.
    . Sounds like a good idea if he is pasting into a Forum. Then he could also try the same using the BB Code generator in these as well ( The latest Mr Excel HTML Maker is also in this package )
    Post Range Screenshots (Win & Mac)- see bottom page here
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv

    . He may be interested ( as I am ) in taking that BB Code or HTML Code for a spreadsheet that is in the Clipboard and pasting that into WORD or similar such that it comes out as a Table. ( If you simply paste from the clipboard you get a HTML code or BB Code . )
    . If he goes down that route, he could possibly do all that with a Code as he can control all the pasting into a WORD document in the same macro. ( But do not ask me how - I am just getting the hang of VBA in Excel )
    . -- Any ideas how to do that ??

    Thanks
    Alan
    Last edited by DocAElstein; May 20th, 2015 at 11:04 AM.

  4. #4
    New Member
    Join Date
    Jan 2009
    Posts
    32

    Default Re: Converting Excel sheets to jpeg

    Thanks guys..

    For some reason my Excel will not run the MR Excel HTML Maker as access to the VB project is not trusted? I have been able to create HTML files in the past by saving the excel spreadsheet as a web page, but have no idea how to get these files on line without taking out web space? which is why I have stuck with the picture route..

    Is there any VBA that can help me?

  5. #5
    Banned user
    Join Date
    May 2014
    Location
    Germany
    Posts
    1,336

    Default Re: Converting Excel sheets to jpeg

    Quote Originally Posted by mickyflash View Post
    ......

    For some reason my Excel will not run the MR Excel HTML Maker as access to the VB project is not trusted? .......

    . One of the links in my signature has some notes I made on getting the Mr Excel Tools up and running.....
    .. here is a small extract that might help here

    „……….( If it is not there or any other problems crop up along the way, then this may help: “. - Click the Office button at the top left of the Excel window -> Excel Options -> Trust Center -> Trust Center Settings... -> Macro Settings -> Tick "Trust access to the VBA project object model" -> OK -> OK “ ) . – If this is necessary then closing and reopening Excel may or may not also be required before the new stuff is displayed or available………“

    Alan..

  6. #6
    Board Regular
    Join Date
    Oct 2007
    Posts
    4,467

    Default Re: Converting Excel sheets to jpeg

    Quote Originally Posted by mickyflash View Post
    is there a way automating any or all of this procedure with VBA/Macro?
    See http://www.mrexcel.com/forum/excel-q...ml#post4063893
    DocAElstein likes this.

  7. #7
    Banned user
    Join Date
    May 2014
    Location
    Germany
    Posts
    1,336

    Default Re: Converting Excel sheets to jpeg

    Wow!!!
    That code at that link is great! Thanks John!

    . I just tried it.. And it works for me straight away…! and it is a Mega Quick new way for me to make an image of a Spreadsheet Range ( Of course I only do that very occasionally in Threads, as the Screenshot Tools that give a screenshot that is copy able to a worksheet is preferred. But it is very useful to have when occasionally appropriate to use.)

    Thanks again

    Alan Elston

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com