Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Is there any script to export an specific Graphic (Pivot Table) in a specified workspace?
Thanks!
Dom
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!
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...