topic Scheduling Export image to Excel through a batch file not working in QlikView

Scheduling Export image to Excel through a batch file not working

amars — Wed, 20 Jun 2012 07:59:59 GMT

Hi all,

We are trying to schedule an export image to excel through a batch file, so user's have access to the file to a shared location.

We are using qlikview 9.0 SR6 for development.

Now the macro for export image to excel contains the below line

Set obj = ActiveDocument.GetSheetObject("CH02")

obj.CopyBitmapToClipboard

XLDoc.Sheets(kost).Range("B8").Select

XLDoc.Sheets(kost).PasteSpecial DataType=wdPasteBitmap

Now when the macro is excuting PostReload it does not get a reference to Chart CH02

as the line ActiveDocument.GetSheetObject can not get the reference

(as the document is not active & getting reloaded through a batch file)

Do any one of you have any solution (except using a publisher) for this macro to work?

Please suggest & thanks in advance.

Amar

deepakk — Wed, 20 Jun 2012 08:06:12 GMT

HI Amar,

if your scheduling it from windows scheduler then it should work.

or try the same on QV 9 SR7.

Deepak

amars — Wed, 20 Jun 2012 08:40:27 GMT

Sorry Deepak, it is not working through a windows schedular as well.

deepakk — Wed, 20 Jun 2012 09:01:14 GMT

hi,

Can you attach the application so that I can check it my end.

Deepak