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

[#1]

Hello,

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

Thanks!

Dom

[#2]

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]

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...