Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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?
Unfortunately macros won't work on ajax.