Paste variable text into WORD based on Qlikview analyses

[#1]

Dear all,

I would like to use my analyses from Qlikview into Word for reporting purposes, based on a Word template in which I can pasted text and charts from Qlikview in predefined areas. Is this possible or should I just copy and pasted the text from Qlikview?

Thanks in advance.

Regards,

Rishi

[stephencredmond]

Hi Rishi,

It would be possible but you need to write macros.

The macro code to copy a chart image to the clipboard is:

ActiveDocument.GetSheetObject("CH01").CopyBitmapToClipboard

Then you could write the appropriate code in Word's API to paste that at a Word Bookmark position.

Might be a lot of work, but worth it if it is something you will do on a regular basis.

Regards,

Stephen