View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Spike[_3_] Spike[_3_] is offline
external usenet poster
 
Posts: 9
Default Save as JPG or PNG

Is there any way to save a range/selection of excel cells as a jpg or png or
any picture format.

I have a graph on an excel page, and i want the jpg to also contains the
information in the cells about it.

I know how to save the chart by itself....
ActiveChart.Export Filename:=MyFiles.BuildPath(ScansPath, TestNumber) & " "
& RunNumber & ".png", FilterName:="PNG"

But have no idea how to print/export a page to a picture format.

Any help at all would be great, thanks,

--
Jeff "Spike" Zapinski
FAS Project Engineer