Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to extract a picture from an Excel worksheet into a picture fi
Tried to extract a picture from an Excel worksheet and save it as a *.jpg /
*.gif / *.bmp file - don't know how to do. Anyone knows how to do that? Same goes for Word. |
#2
|
|||
|
|||
try this.
Sub ExportChartJPG() ActiveChart.Export Filename:="C:\a\MyChart.jpg", _ FilterName:="jpeg" End Sub -- Don Guillett SalesAid Software "SARANJAI" wrote in message ... Tried to extract a picture from an Excel worksheet and save it as a *.jpg / *.gif / *.bmp file - don't know how to do. Anyone knows how to do that? Same goes for Word. |
#3
|
|||
|
|||
Thanks for your advice. But honestly, I don't know what you mean...:-(
"Don Guillett" wrote: try this. Sub ExportChartJPG() ActiveChart.Export Filename:="C:\a\MyChart.jpg", _ FilterName:="jpeg" End Sub -- Don Guillett SalesAid Software "SARANJAI" wrote in message ... Tried to extract a picture from an Excel worksheet and save it as a *.jpg / *.gif / *.bmp file - don't know how to do. Anyone knows how to do that? Same goes for Word. |
#5
|
|||
|
|||
Hi Don. When I tried your macro I got the following error:
Run-Time error '91': Object variable or With block variable not set. I'm afraid I don't have clue what that means, being VBA illiterate. Oh, by the way, thanks for all your help in the many other posts. -- Sincerely, Michael Colvin "Don Guillett" wrote: This is an excel macro. copy/paste into a regular excel macro moduleassign to a buttonchange to suit the path desiredselect the chart desired and execute the macro -- Don Guillett SalesAid Software "SARANJAI" wrote in message ... Thanks for your advice. But honestly, I don't know what you mean...:-( "Don Guillett" wrote: try this. Sub ExportChartJPG() ActiveChart.Export Filename:="C:\a\MyChart.jpg", _ FilterName:="jpeg" End Sub -- Don Guillett SalesAid Software "SARANJAI" wrote in message ... Tried to extract a picture from an Excel worksheet and save it as a *.jpg / *.gif / *.bmp file - don't know how to do. Anyone knows how to do that? Same goes for Word. |
#6
|
|||
|
|||
How about just selecting it, copying it, and pasting it into a different program
(Paint??) and saving from there? If you're version of excel can save a file as "Web Page (*.htm;*.html)" (under the "save as type" box on the File|SaveAs dialog), then when you save it, you'll get a new folder with all the pictures under the folder with the file. That new folder will be named like filename_Files. If I recall correctly, this was added with xl2002. SARANJAI wrote: Tried to extract a picture from an Excel worksheet and save it as a *.jpg / *.gif / *.bmp file - don't know how to do. Anyone knows how to do that? Same goes for Word. -- Dave Peterson |
#7
|
|||
|
|||
Since your first post did not specify whether you are exporting a chart or a picture within excel:
Try Andy Pope's add-in for exporting Pictures: http://www.andypope.info/vba/gex.htm or Aaron Bloods Chart to Picture exporter http://www.xl-logic.com/pages/addins.html These are both add-ins so you just have to load them to use. No vba on your part if that is outside your comfort level. Quote:
__________________
Justin Labenne www.jlxl.net |
#8
|
|||
|
|||
My first post????
<vbg JustinLabenne wrote: Since your first post did not specify whether you are exporting a chart or a picture within excel: <<snipped |
#9
|
|||
|
|||
Sorry Dave, not yours, I dont even pay much attention to the qoutes at the bottom so I did not realize it would be construed that way. My apologies, gotta get used to this forum design, it's a bit different than others that I post on.
Quote:
__________________
Justin Labenne www.jlxl.net |
#10
|
|||
|
|||
No problem. I was just pulling your chain a bit!
JustinLabenne wrote: Sorry Dave, not yours, I dont even pay much attention to the qoutes at the bottom so I did not realize it would be construed that way. My apologies, gotta get used to this forum design, it's a bit different than others that I post on. SARANJAI Wrote: Tried to extract a picture from an Excel worksheet and save it as a *.jpg / *.gif / *.bmp file - don't know how to do. Anyone knows how to do that? Same goes for Word. -- JustinLabenne -- Dave Peterson |
#11
|
|||
|
|||
Hi Dave,
Thanks a lot for your advice. It worked well! Actually, it is soo simple that I should have had this idea by myself. Guess, I couldn't see the forest due to so many trees...:-) Cheers! "Dave Peterson" wrote: How about just selecting it, copying it, and pasting it into a different program (Paint??) and saving from there? If you're version of excel can save a file as "Web Page (*.htm;*.html)" (under the "save as type" box on the File|SaveAs dialog), then when you save it, you'll get a new folder with all the pictures under the folder with the file. That new folder will be named like filename_Files. If I recall correctly, this was added with xl2002. SARANJAI wrote: Tried to extract a picture from an Excel worksheet and save it as a *.jpg / *.gif / *.bmp file - don't know how to do. Anyone knows how to do that? Same goes for Word. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet | Excel Discussion (Misc queries) | |||
Extract Command in Excel 1 | Excel Discussion (Misc queries) | |||
exporting excel worksheet to word | Links and Linking in Excel | |||
How do I convert an existing MS Excel worksheet tracking a simple. | Excel Discussion (Misc queries) | |||
Need to remove a password that noone placed on Excel worksheet. | Excel Worksheet Functions |