Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
raynac
New Contributor III

Macro - Opening an Excel File After Creation

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!

Tags (2)
Community Browser