Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to export a range to a picture ?
Hello,
I am trying to create a macro that could export (save) a range (fo example {A1:T20} to a picture (bitmap). A little bit like a printscreen or a screen capture... Anybody have any idea if it is possible ? Please advise, regards, Ayat -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to export a range to a picture ?
Hi Ayato
I have some code for this at http://www.mvps.org/dmcritchie/excel/xl2gif.htm HTH. Best wishes Harald "Ayato " skrev i melding ... Hello, I am trying to create a macro that could export (save) a range (for example {A1:T20} to a picture (bitmap). A little bit like a printscreen or a screen capture... Anybody have any idea if it is possible ? Please advise, regards, Ayato --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to export a range to a picture ?
Hi Ayato,
I think it was Jim Wilcox who first suggested copying the range to a chart and then using the chart.export method to save as a gif. Something like this will do it; Sub CopyRngToGif() Dim MyRange As Range Application.DisplayAlerts = False Set MyRange = Worksheets(1).Range("A1:C6") MyRange.CopyPicture With Charts.Add .Paste .ChartArea.Clear .Export "C:\temp\MyRange.gif" .Delete End With Application.DisplayAlerts = True End Sub Ed Ferrero http://edferrero.m6.net Hello, I am trying to create a macro that could export (save) a range (for example {A1:T20} to a picture (bitmap). A little bit like a printscreen or a screen capture... Anybody have any idea if it is possible ? Please advise, regards, Ayato --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export range to text file | Excel Discussion (Misc queries) | |||
Export Picture | Excel Programming | |||
Export range to html | Excel Programming | |||
How to export a picture or chart from Excel to PowerPoint? | Excel Programming | |||
Export picture as gif in Excel | Excel Programming |