how to export qlikview charts to excel using macros?

[udaya_kumar]

hi,

i tried some macros to export charts to excel, but it is exporting chart as data in the excel.

but i want it as image in powerpoint, not as a data.

so how we can achieve this using macros?

[forte]

Hi Udaya ,

Just try something like this :

ActiveDocument.GetSheetObject("CH01").CopyBitmapToClipboard

and then paste it into excel.

Hope it helps,

Regards

[udaya_kumar]

hi forte,

thanks for reply,

but how to paste it in excel?

what is the macro code to paste to excel?

[forte · Accepted solution]

Hello again ,

Supposing that you want to create a new excel, something like this :

set XLApp = CreateObject("Excel.Application") ' Define Object

XLApp.visible = true
Set XLDoc = XLApp.Workbooks.Add 'Open new workbook
set sheets = XLDoc.Sheets

ActiveDocument.GetSheetObject("CH01").CopyBitmapToClipboard

  
sheets(1).Paste

[udaya_kumar]

thanks for help forte,

it worked well..

thank u very much

[#6]

Hi Francisco,

I have a requirement where i need to copy the image of the individual charts from tab to make it available to print.

Is it possible to that ??

Thanks in advance

Walter