How to Export Qlikview sheets as an image to Excel?

[#1]

Hi,

Can any one of u pls explain me how to export the Qlikview sheets as an image to Excel?

[#2]

Thank you all for the answers. The below macro is working fine.

sub test2

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

XLApp.Visible = True 'Visible set as true

set XLDoc = XLApp.Workbooks.Add 'Open new workbook

set XLSheet = XLDoc.Worksheets(1) 'Select sheet where data should be pasted

ActiveDocument.Sheets("Main").CopyBitmapToClipboard

XLSheet.Paste XLSheet.Range("A1") 'Paste data into cell

end sub

But this is applicable only for exporting one sheet. How can i proceed if i need to export 2 or more sheets??? Please help.

Thanks

[udaya_kumar]

Hi,

i am able to export the sheet as an image to excel, but am getting one problem.

that is, the objects in sheet are not copied fully. it is copying only few objects and the objects at the bottom is not exporting into excel.

what could be the problem?

can anyone help me?

[jaspal_icon]

Hello Uday Did you get the solution for this, the Sheet is not fully copying. Some crop from left right and bottom in final image.