Macro Help

[#1]

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]

check this:

[IAMDV]

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