PDA

View Full Version : [SOLVED] SaveAs a picture or a shape or a Chart from a sheet



Erdin? E. Ka
10-17-2006, 02:39 PM
Hi, it's me again. :hi:

I want to SaveAs a picture or a shape or a Chart from a sheet to a folder.

Example:
Name in Excel:____Folder:______New Name of the File:
Picture 1_________C:\Pi_x______Picture1.jpg
Shape 1__________C:\Sh_x_____Shape1.jpg
Chart Area________C:\Ch_x_____Chart1.jpg

Is it possible? Or any ideas about it?

Thanks in advance.

Bob Phillips
10-17-2006, 03:15 PM
http://www.andypope.info/vba/gex.htm

Erdin? E. Ka
10-17-2006, 05:25 PM
Andy Pope must be a wizard.:p

Thank you xld to the help. :friends:

Bob Phillips
10-18-2006, 01:48 AM
Andy Pope must be a wizard.

He is certainly good with charts in Excel.

Erdin? E. Ka
10-18-2006, 03:29 AM
He is certainly good with charts in Excel.

I am sure that.



By the way,

xld, i used to like Ivan Zamorano and Marcelo Salas from Chile. And you are the third person. You helped me so much until this time.

Thank you very much.:friends:

Bob Phillips
10-18-2006, 04:54 AM
By the way,

xld, i used to like Ivan Zamorano and Marcelo Salas from Chile. And you are the third person. You helped me so much until this time.

Erdin?,

I am not actually from Chile. I was in Chile when I joined VBAX, so I used the Chilean flag, and I like it so I never changed it. I am actually in the kingdom of Wessex these days :yes.

Erdin? E. Ka
10-18-2006, 07:01 AM
Hi xld,

Actually it makes no difference that where are you from.
The truth of the matter is you and your helps and VBAX.

In this way, thank you so much to all helps and thanks to all VBAX members and Admins|Mods.

Take care.

:friends: