Sheet as image

[#1]

Hi,

I am trying to export the whole sheet as the image using macro. I am getting the blank jpg file stored. But it is working fine for the single object.

ActiveDocument.GetApplication.WaitForIdle

ActiveDocument.Sheets(

ActiveDocument.Sheets(

"Dashboard").ExportBitmapToFile "C:\statusreport.jpg"

I am using Qlikview 9.0 version

Please help me ...

[#2]

Hi,

I have found the reason for getting blank jpg file. But please confirm is it functionality ...

Consider there are three sheeets as SH1,SH2,SH3 in the QVW file.If the QVW file is opened with default sheet is SH1. Your macro is to export the Sheet SH2 as an Image. Then it is getting exported as blank Image.For the object the image itself is not getting generated.

Hence the conclusion is macors will work incase of export the Object/Sheet as an image if the relevant sheet is open in the QVW document. I am not sure about the other export options like excel,pdf,word...

Please help me to understand the functionality .Also please let me know if there is any workaround.

I am using QlikView 9.0 SRS 5. i have not scheduled it.

[boorgura]

I cant affirm on the functionality.

But can suggest something - why dont try to include activate sheet statements in your macro itself.

To activate sheet 2 and then export to JPG and then activate sheet 1 back again.

If that works - you can confirm that what you thought was right.

Also, this should solve your task.

Please do let me know if it works.

[#4]

What is the trigger of your exported image? Have you had any issues running this as part of a scheduled vbScript and the window not being maximized when the image is exported? I have been able to export reports as images in a couple of different ways but would like to do it as a scheduled windows task during the night and the images ready when I get to the office in the morning. Any suggestions here?

[#5]

Hi Rocky,

Thanks for your suggestion. it is working as you said. But still there is a problem like sometimes it is working fine but sometimes not. I am trying to object from one sheet and entire sheet from the same code. Do i need go with some other way ..Please suggest. Also when i am trying to copy the image of the sheet it is getting truncated. Any idea to overcome that...Please suggest.