Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Saving Range of Cells as Image File

I've used the Export method to save a chart as a .gif image.

I now have a chart formated on a worksheet with additional text boxes and
cells.
I was wondering if there is a way to export the printed version of the
range as
an image file, which will include any text boxes or graphs located within
the range?

Can

Selection.CopyPicture Appearance:=xlPrinter, Format:=xlPicture

be used to save an image file? It copies all the pertinent info to the
clipboard.

Just wondering if there is anything within Excel that will do this.
I'm not really interested in a PDF writer or third party software.

Thanks.

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
Capturing and saving image from a url link-CPEARSON samboy Excel Discussion (Misc queries) 1 January 12th 09 06:01 PM
Saving clipboard image as BMP through VBA in Excel Elliot Excel Discussion (Misc queries) 0 September 17th 08 03:22 AM
Saving file without empty cells iashorty Excel Discussion (Misc queries) 2 July 10th 08 01:37 PM
Saving a pre-determined range of cells as text? [email protected] Excel Discussion (Misc queries) 2 March 27th 07 11:58 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 11:04 PM.

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

About Us

"It's about Microsoft Excel"