Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
In the edit macro window > enable the system access ,
You could find this option in the bottom left of the edit macro window
Thank you for the answer,That is correct?
but I have error
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.
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
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
Avinash
Thank you very much
that was perfect
Cool if you have got answer please mark the correct and helpful answers
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