2 Replies Latest reply: May 15, 2014 9:58 AM by JoeB _ RSS

    JetExportSummary

    JoeB _

      I am using Monarch V6 Pro on a XP PC with Excel 2002.  I would like to run a Monarch .prj file from excel and export and replace a table in an existing excel file using the  JetExportSummary method.  Unfortunately, I keep getting this error message

       

      “Compile error: Expected:=”

       

      when I type the line

       

      MonarchObj.JetExportSummary ("C:DataTest

        • JetExportSummary
          Stephen Reid

          Hi Joe,

           

          This is a stab in the dark to be honest with you as I don't have pro and therefore cant use Jet Export, but try this:

           

          Change

          Dim openfile, t As Boolean

          to

          Dim openfile, t, exportfile As Boolean

           

          And

          MonarchObj.JetExportSummary ("C:DataTest 2BlueBook.xls","Acres",0)

          to

          exportfile = MonarchObj.JetExportSummary ("C:DataTest 2BlueBook.xls","Acres",0)

           

          Hope this helps  smile.gif[/img] 

          Stephen

          • JetExportSummary
            JoeB _

            Thanks Stephen

             

            Your suggestion worked perfectly.  Jet Export is a powerful feature that will save my company a lot of time in the future.

             

            Thanks again for your help.