Hello everybody,
I'm very sad. I had a solution for my problem, but then my pc is crashed without saving anything
I try to export one table of QlikView to an excel-file in an already existed sheet called "data sheet" because in the other sheets of the file are expressions which are used cells of this one. So I can't delete the existed sheet and add a new one with the same name. This doesn't work; the error is reference! then.
The following code opens the excel-file, saves it and closes it, but it doesn't add the table
sub ExportExcel()
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = true
Set xlDoc = xlApp.Workbooks.Open("C:\test.xls")
xlApp.DisplayAlerts = false
Set SheetObj = ActiveDocument.GetSheetObject("CH09")
SheetObj.CopyTableToClipboard true
Set xlSheet = xlDoc.Sheets("data sheet")
xlDoc.Sheets("data sheet").Range("A1").Select
xlDoc.Sheets("data sheet").Paste
xlApp.ActiveWorkBook.Save
xlDoc.Close
xlApp.Quit
End sub
What's wrong with it?
Regards vicky