Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Can I get a chart to an image file?

My excel speadsheet at work has 2 charts on it and I need
to send them out to my colleagues does anyone know any vb
to have a button which will create 2 files on my desktop
which are images containing the two charts?


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Can I get a chart to an image file?

Look the export method of the Chart object.

--
Regards,
Tom Ogilvy

"Lynda" wrote in message
...
My excel speadsheet at work has 2 charts on it and I need
to send them out to my colleagues does anyone know any vb
to have a button which will create 2 files on my desktop
which are images containing the two charts?




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Can I get a chart to an image file?

Thanks Tom how would I do that in Visual basic code I
have never used it before.

All I need is a button. I can get that from the form
toolbar but I dont know how to find export on the menu.

-----Original Message-----
Look the export method of the Chart object.

--
Regards,
Tom Ogilvy

"Lynda" wrote in

message
...
My excel speadsheet at work has 2 charts on it and I

need
to send them out to my colleagues does anyone know any

vb
to have a button which will create 2 files on my

desktop
which are images containing the two charts?




.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Can I get a chart to an image file?

There is no export menu I don't believe. I said Export METHOD. Anyway, see

Don Guillet's post .

He provided sample code.

--
Regards,
Tom Ogilvy

"lynda" wrote in message
...
Thanks Tom how would I do that in Visual basic code I
have never used it before.

All I need is a button. I can get that from the form
toolbar but I dont know how to find export on the menu.

-----Original Message-----
Look the export method of the Chart object.

--
Regards,
Tom Ogilvy

"Lynda" wrote in

message
...
My excel speadsheet at work has 2 charts on it and I

need
to send them out to my colleagues does anyone know any

vb
to have a button which will create 2 files on my

desktop
which are images containing the two charts?




.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export Org chart as image Steve G[_3_] Charts and Charting in Excel 6 May 27th 08 09:05 AM
Image Export - Org Chart Steve G[_2_] Excel Worksheet Functions 1 May 22nd 08 08:48 PM
Export Pie Graph Chart as Image [email protected] Excel Discussion (Misc queries) 1 November 25th 06 06:57 PM
How to save a bar chart as an image file programmatically? Fool Excel Programming 1 August 2nd 04 01:35 PM
Export the worksheet background image as an image file - possible? DataFreakFromUtah Excel Programming 2 April 10th 04 04:49 PM


All times are GMT +1. The time now is 10:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"