Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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?

Posted on 2014-01-17
3
Medium Priority
?
386 Views
Last Modified: 2014-01-22
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
0
Comment
Question by:f19l
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 6

Expert Comment

by:Mahesh Bhutkar
ID: 39788583
In Excel 2003 there's a little trick. Hold down the Shift key and choose Edit from the menu. Note that instead of Copy it offers Copy Picture—select that item. You'll be asked whether to copy as Picture or Bitmap, and whether to copy the image As shown on screen or As printed. You'll almost always want to choose Bitmap and As shown on screen. If you choose Picture, the image will be copied as a resizable Windows Metafile, and not all programs can use that format.

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
0
 

Author Comment

by:f19l
ID: 39788799
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.
0
 
LVL 6

Accepted Solution

by:
Mahesh Bhutkar earned 2000 total points
ID: 39799578
This is the simplest manual process you can apply.
Just select the area & copy (Ctrl - C) it from Excel, open Mspaint and just paste (Ctrl - V). Save the file as JPEG.

Otherwise you have to purchase some tools for same.
http://www.print-driver.com/how-to/convert-excel-to-jpeg
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
In this article I share how to make a vector texture from a digital image. Vector textures are useful because they are scalable without losing in image quality. I'll be using Adobe Photoshop to adjust the highlights and contrast of a digital imag…
In this tutorial viewers will learn how to use the Pathfinder tool in Illustrator to create advanced shapes Draw two shapes: A circle and a rectangle: Select both shapes, hold down the Alt key, click and drag to create 4 copies.: Select the first pa…
In this tutorial viewers will learn tricks for more effective scaling of vectors in Illustrator Open a document with vectors to be scaled in Illustrator: Normally, items do not keep their proportions when scaled. To fix this, hold down the shift key…
Suggested Courses

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question