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

       

       

       

      Thanks!