f19l
asked on
How do I convert a range in excel that contains a graph and table of data into a JPEG image that I can attach to an email and send?
Hello,
I would like to know what is the VB code that will convert a range in excel that contains a graph and table of data into a JPEG image that I can attach to an email and send? The range will vary but will be named.
Thanks,
f19l
I would like to know what is the VB code that will convert a range in excel that contains a graph and table of data into a JPEG image that I can attach to an email and send? The range will vary but will be named.
Thanks,
f19l
ASKER
I have tried to look at the VB code for converting excel to JPEG file and see if I can apply it to my needs but cannot.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Naturally, it's different in Excel 2007. To copy a range as a picture, in the Home ribbon's Clipboard pane click the Down arrow under Paste, choose As Picture from the menu, and then Copy as Picture. (If you're surprised at having to choose Paste when you want to copy, remember this is coming from the same company that makes you click Start when you want to shut down.) As in Excel 2003, you'll generally want to copy it as Bitmap and As shown on screen.
But wait! In either version it can be easier, much easier. Just highlight the data range, chart, or whatever and press Ctrl-C. Excel puts the data into the clipboard in a variety of formats, so different programs can make use of it. It includes both formatted and unformatted text, as well as a format proprietary to Excel. And it also copies the data area as an image—Excel 2007 supplies four distinct image formats. When you switch to your graphics program and press Ctrl-V, the program will choose the clipboard format that suits it best. You can select & copy (Ctrl - C) the area from Excel, open Mspaint and just paste (Ctrl - V). Save the file as JPEG.
For more information check, http://www.pcmag.com/article2/0,2817,2269778,00.asp
http://www.print-driver.com/how-to/convert-excel-to-jpeg