Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
fkeuroglian
Partner - Master
Partner - Master

Open chart as an image

Hi people, i would like to know if there is a way to export a chart into an image, but i dont want to export to a folder only open in paint or power point or another picture viewer.

could be using macro or something like this?

i attached an example , i have to export to excel(i done it) and i have to export a chart as jpg or png or another format

thank you a lot

Fernando

3 Replies
tresesco
MVP
MVP

Sub PrintCurrentSheet

Set objWord = CreateObject("Word.Application")

objWord.Visible = True

Set objDoc = objWord.Documents.Add

Const wdOrientLandscape = 1

objDoc.PageSetup.Orientation = wdOrientLandscape

ActiveDocument.GetSheetObject("CH01").CopyBitmapToClipboard

objWord.Selection.Paste

'Const wdAlignParagraphCenter = 1

'objDoc.Paragraphs(1).Alignment = wdAlignParagraphCenter

'objDoc.PrintOut()

'DO WHILE objWord.BackgroundPrintingStatus > 0

'LOOP

'objWord.Quit wdDoNotSaveChanges

'Set objWord = Nothing

'Set objDoc = Nothing

END SUB

fkeuroglian
Partner - Master
Partner - Master
Author

Thank you tresesco,  but works ok in desktop mode but not in full browser ajax could be?

is there any way to export behind the acces point?

tresesco
MVP
MVP

Unfortunately macros won't work on ajax.