2 Replies Latest reply: Jul 25, 2012 2:25 AM by Deepak Vadithala RSS

    Macro Help

    Rebecca Molstad

      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