export and save worksheet as a picture.

**Diesel13** · 01-31-2010, 04:39 PM

Hi everyone,

Is there a way to export and save the contents and table layout of a worksheet as a picture ( say jpeg )?

Basically what I would love to do is that when I save the workbook, a certain worksheet named " Fax " is saved to my desktop as a picture (as a snapshot). What would even be better is that the said file was named with simply the date !

The purpose of this is so I can email it to a very non computer guy who thinks that excel is only a gum . . .

I know this is weird but you guys are the best, you helped me a lot to make my spreadsheet.

Thanks, Mike.

P.S. I attached a copy of my spreadsheet
I use office 2007.

**martindwilson** · 01-31-2010, 06:52 PM

try this code you can assign it to a button
using some code from here adapted slightly
http://www.xtremevbtalk.com/showthre...=574247#574247

Please Login or Register  to view this content.

**Diesel13** · 01-31-2010, 07:22 PM

Well, as I said in previous posts, I'm not that good at this but I try.

Here is what I tried . . .

Please Login or Register  to view this content.

but I get an error

Run-time error '1004'
invalid parameter

in this line

Please Login or Register  to view this content.

stuck, help ?

**martindwilson** · 01-31-2010, 07:41 PM

i think its the code is diferent in 2007 grrrrrrrrrrrrrrrrrrrrrrrrrrr
i'll pm andy pope to have a look

**Andy Pope** · 02-01-2010, 04:18 AM

Not really a '07 problem. Just a case of trying to delete something that does not exist.

When the source data is set to A1 there is not data to plot so no seriescollection.
This revision removes all those series that exist.

Please Login or Register  to view this content.

**mha** · 02-01-2010, 04:52 AM

I suggest something easier to help, here are the steps:
1) Open the sheet and try to fit in the screen
2) CTRL+Sys Rq buttons to save a picture of the screen
3) Open paint, new file and paste (CTRL+V)
4) Save the file as JPG, and exist
5) Open the JPG in MS Office Picture Manager (Start, Programs, MS Office, MS Office Tools, MS Office Picture Manager)
6) Edit picture and Crop it to the limits you need
7) Save and exit

mha

**martindwilson** · 02-01-2010, 04:52 AM

thanks for that andy! mha thats not what the op required anyone can copy the screen!
diesel 3
if you put that in the workbook module

Please Login or Register  to view this content.

if you're not sure where that is see link in my signature, it should auto save a copy to desktop when saved

**Diesel13** · 02-01-2010, 09:24 AM

Hi, cant get it to work.

here is what I tried, exactly this code but adjusted the values for my use.

Please Login or Register  to view this content.

in the line . . .

Sheets("fax").Range("A1:C29").CopyPicture Appearance:=xlScreen,

does it have to be . . .

Range("A1:G20")

or do I put in the area of the page I need to be saved I.E. A1:C29 ?

**arthurbr** · 02-01-2010, 09:28 AM

has the " Copy Picture" menu dissapeared in 2007?

**Andy Pope** · 02-01-2010, 09:30 AM

Copy As Picture is part of the Paste button on the Home tab.

Can you clarify "cant get it to work". Do you get an error? No file?

**Diesel13** · 02-01-2010, 09:38 AM

Sorry, just not in the drop down list when I try to run the macro.

Yes I saved, closed and reopened.

Jut cant see it.

**Andy Pope** · 02-01-2010, 09:48 AM

If you are using the BeforeSave event then the code should be in the Thisworkbook object.
And you will not see it listed in the Macro dialog.

The code will run when the event fires. To fire the event save the workbook.

If the code does not run then maybe you have the code in a standard code module.

**Diesel13** · 02-01-2010, 09:59 AM

That was it !

I had it in the wrong module, I put it in thisworkbook and BAM !!!!!!
Thanks, now a little tweaking and I'll post back the results . . .

**martindwilson** · 02-01-2010, 10:09 AM

i just put this on an excel2007 machine and it works fine

**Diesel13** · 02-01-2010, 12:41 PM

Thanks guys,

Tweaked it just a tad (to input the values I needed (the code was perfect)).

I included in this post a copy of the saved picture ( all nice and perty )

and a copy of my spreadsheet.

Take a look at the calculations worksheet . . . Star-Trek LCARS theme !

took me a little while but I believe that the eye candy factor is very well worth the effort.

Thanks again for all your input could not have done it by myself, not this year anyway !

Mike. (Office 2007)

**Diesel13** · 02-01-2010, 12:44 PM

actually I got another favor, most likely childsplay but I googled it and could not find the answer . . .

how can I change it that when it saves the file, the date format would be " 01 February 2010 " ?

**Diesel13** · 02-01-2010, 03:39 PM

Found it, this was how . . .

"dd-Mmmm-yyyy"

Thanks everyone for all the help again.

**romilshah** · 10-22-2010, 02:33 PM

When I save the selected range as gif file, my image is align to leftmost top. How can I center the image. I have attached the image file for your reference.

Thank you.

**martindwilson** · 10-22-2010, 05:04 PM

romilshah please start a new thread linking to this on if relevant

export and save worksheet as a picture.

LinkBack

Thread Tools

Rate This Thread

Display

export and save worksheet as a picture.

Re: export and save worksheet as a picture.

Re: export and save worksheet as a picture.

Re: export and save worksheet as a picture.

Re: export and save worksheet as a picture.

Re: export and save worksheet as a picture.

Re: export and save worksheet as a picture.

Re: export and save worksheet as a picture.

Re: export and save worksheet as a picture.

Re: export and save worksheet as a picture.

Re: export and save worksheet as a picture.

Re: export and save worksheet as a picture.

Re: export and save worksheet as a picture.

Re: export and save worksheet as a picture.

Re: export and save worksheet as a picture.

Re: export and save worksheet as a picture.

Re: export and save worksheet as a picture.

Re: export and save worksheet as a picture.

Re: export and save worksheet as a picture.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions