Scheduling Export image to Excel through a batch file not working

[amars]

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]

HI Amar,

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

or try the same on QV 9 SR7.

Deepak

[amars]

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

[deepakk]

hi,

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

Deepak