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

[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:DataTest2BlueBook.xls","Acres",0)
to
exportfile = MonarchObj.JetExportSummary ("C:DataTest2BlueBook.xls","Acres",0)

Hope this helps smile.gif
Stephen

[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.