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?