Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help - Script to export a Graphic (Pivot Table) automatically

Hello,

Is there any script to export an specific Graphic (Pivot Table) in a specified workspace?

Thanks!

Dom

11 Replies
Not applicable
Author

Don't ask me why, but when I use a Workbook instead as a object instead of Excel, it works:

---

sub ExportAnual

Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set WB = objExcel.Workbooks.Add
ActiveDocument.GetSheetObject("CH01").CopyTableToClipboard True

WB.ActiveSheet.Paste
WB.SaveAs "C:\path\Ranking\test3.xls"
WB.Close

End Sub

---

Just need to know how overwrite in Qlikview's VB Script.

Thanks!

chematos
Specialist II
Specialist II

This is not working to export??

objExcel.ActiveSheet.Paste

objExcel.Export

I use that to overwrite the excel everytime, may be exists a function to clear ActiveSheet before copy the table... I really don´t know.

You're welcome, I'm glad you get a solution but I also don't know why is working like that...