0 Replies Latest reply: Aug 21, 2012 10:11 AM by Claudia Zwick RSS

    Help with Macro

      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