Export range as JPG

**strep21** · 10-25-2008, 11:39 AM

Hi all,
Using and adapting some from http://www.mvps.org/dmcritchie/excel/xl2gif.htm and http://www.ozgrid.com/forum/showthread.php?t=88851 I succeeded in exporting name ranges as jpg's.
However, I still have a 'problem' : I would like to set the dimensions of the jpg in code.
Is there any help on the way ?
Thanks
Eddie

An additional question on this subject.
The ranges I am exported have a green background (for publishing on a website). When I do the export in Excel XP, everything looks fine (except for the automatic sizing), but when I use Excel 2007 there is a white border around the jpg.
Any ideas about this.
Thanks again.
Eddie
My code :

Please Login or Register  to view this content.

**strep21** · 11-01-2008, 02:49 PM

Bump.

I can imagine this subject is not so common, but I'd like to try again

For the first part of my question (the redimentioning) I found a solution.

I'll rephrase the second part, just in case I wasn't clear
I export a range (well, up to 44 ranges in fact), with a green background, to jpg.
In Excel XP this works without problems.
In Excel 2007 there is a white border around the (green) jpg.
Has anybody an idea why ? And more important, how to avoid that border ?

Eddie

**Andy Pope** · 11-02-2008, 05:54 AM

Can you post code or link to the solution of resizing?

The border is produced by the chart export method and is difficult to remove.

If you can work with bmp image then the PastePicture workbook at Stephen Bullen's site should remove the border.
http://www.oaltd.co.uk/Excel/Default.htm

**strep21** · 11-02-2008, 08:22 AM

Thanks for responding Andy.
The trick for resizing lies in first copying the range into a new workbook (normal sheet, not a graphic), resize, copy again and pasting in another new workbook as bmp. Followed by the 'normal' export as jpg.
My present code :

Please Login or Register  to view this content.

I had a (quick) look at the PastePicture.zip you mentioned, but I don't immediately see how to use or incorporate it (I'm totally ignorant when it comes to API calls, and have no formal programming background).
But, stubborn as I am, I will look at it again

Eddie

**Andy Pope** · 11-02-2008, 08:41 AM

So you increase the thing being turned in to an image rather than manipulate the image afterwards.

If you need more help post back.

**strep21** · 11-02-2008, 10:05 AM

Andy,
The file you mentioned, doesn't work for me in Excel 2007.
Nothing seems to get copied to the clipboard, I can't see how that is supposed to be done/corrected.
Btw, a bmp format as final result wouldn't be acceptable, files would be to big.
I hope I won't have to live with those borders around the pics on my website

I'm not sure what kind of help to ask for, I suppose exporting a range to jgp is not a very common subject, even less in Excel 2007.
Not that I'm giving up

Eddie

**Andy Pope** · 11-02-2008, 10:26 AM

I just added this routine to a code module in that project.
It will export the current selection as a emf image. It will do jpg but the image is large in view if not size.

Please Login or Register  to view this content.

Most people do copypicture/paste or screen grabs. It's only when you are automating this task or doing it repeatedly that code is needed.

**strep21** · 11-02-2008, 08:21 PM

Andy,
I went through the code and the ref you sent me, but I can't seem to get rid of that white border around my exported (wmf in this case) picture.

If you, or anyone else is interested, I attached a my simplified version in both 97-2003 and 2007 format.

Since I'm not familiar at all with the use of API calls, I'll stick to my original code. At least I understand that ( I think :D).
Thanks again for your help.

Eddie

**Andy Pope** · 11-03-2008, 05:10 AM

I just used the xlsm version and created this image. I see no white border.
I added the border to the cells so the boundary is more obvious.

**strep21** · 11-03-2008, 08:44 AM

Andy,
This is almost becoming funny :
- if I export a pic and look at it with e.g. Paint, there is a white border
- if I use the pic in Frontpage, there is a white border
- if I insert the pic in an excel sheet (like in your example). there is no border
Totally confusing to me !
Eddie

Export range as JPG

LinkBack

Thread Tools

Rate This Thread

Display

Export range as JPG

Export range as jpg Excel2007 vs Excel2002

I give up (hate to do that)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions