0 Replies Latest reply: Sep 25, 2014 4:18 PM by Rayna Curtis RSS

    Macro - Opening an Excel File After Creation

    Rayna Curtis

      I have a macro that will export a chart to an Excel file, and I want the file to open on the screen afterwards.

       

      The code I am seeing everywhere around the internet is this (and I swear it's what I was using in Qlikview 8.5) but now that I am on QV 11, it does not seem to work.

       

      Code code code all the way to here setting tmpFile as the file path then:

       

      msgbox tmpFile

       

      obj.ExportEx tmpFile, 1


      Set objExcel = CreateObject("Excel.Application")

      objExcel.Workbooks.Open(tmpFile)

      objExcel.Application.Visible = True

       

      Msgbox "Exported Successfully"

       

      I get the first message box and then I can both see and open the exported file.  But the macro jumps out at that point and the file does not open as it should.  Does anyone know what I am doing wrong?  Any help is appreciated.  Thank you!