I want to export qlikview charts into word..

[fgolmahi]

I want to export qlikview chart in to word

I have the following macro

But it was an error  ..... This Error is : " ActiveX component can't create object: 'Word.Application'   "

Please help me

""

sub WordExport

        Set objWord = CreateObject("Word.Application")

        objWord.visible = true 'false

        set objDoc=objWord.Documents.add

        Const wdOrientLandscape = 1

        objDoc.PageSetup.Orientation = wdOrientLandscape

        ActiveDocument.GetSheetObject("MB02").CopyTextToClipboard 'true

  objWord.Selection.MoveRight

     objWord.Selection.Paste

        ActiveDocument.GetSheetObject("CH44").CopyTableToClipboard true

  objWord.Selection.TypeParagraph

  objWord.Selection.TypeParagraph

  objWord.Selection.MoveRight

     objWord.Selection.Paste

end sub

[avinashelite]

In the edit macro window > enable the system access ,

You could find this option in the bottom left of the edit macro window

[fgolmahi]

Thank you for the answer,That is correct?

but I have error

[Siva_Sankar]

Fatemeh,

This issue most probably occurs in server where there is no microsoft word application.

OR

Install IE plugin from Access Point and after successfull install ,open application and the press Ctrl+Shift+M and give system access to module script.

[Siva_Sankar]

Macro to paste Text Object in Word

[avinashelite · Accepted solution]

no, not in USER preferences.

1.click Ctrl+M // this will open the edit macro window

2. In the left hand side you will see , Requested module security > select system access

3.In the left hand side you will see, Current Local security > select Allow system access

this is resolve this issue , hope this helps you

[fgolmahi]

Thanks siva for your answer

I had previously searched and I used the same example but

Macro is correct in download sample , but I coping the Macro into my qlikview But I have error

[fgolmahi]

Avinash

Thank you very much

that was perfect

[avinashelite]

Cool if you have got answer please mark the correct and helpful answers

[dandaanilreddy]

Hi

Thanks for the script but this script is exporting data from the chart i want the chart image to be exported to word. Can someone help me how to do this

Thanks

Anil