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.
Not applicable

Macro Help

Hi All,

I need help with writing a macro. I have a popup box that asks if the user wants to export to Excel. If the answer is yes, I want the document to copy ObjectID "CH112" into Excel. So far, all I have is the message box, and I don't know how to tell it to Open Excel and export the object. Please help.

Sub ShowPopup



x=MsgBox("Would you like to export search results to Excel?",4,"Export Excel")



End Sub

Thanks!

2 Replies
Not applicable

Re: Macro Help

check this:

Luminary
Luminary

Re: Macro Help

Hi,

Please look at these threads and hope that helps.

Advanced Export to Excel:

http://community.qlik.com/message/8253#8253

Loop Object ID:

http://community.qlik.com/message/15557#15557

You can use combination of both the ideas to suffice your need.

Cheers,

DV

www.QlikShare.com

Community Browser