I create a generic object, then set that object to Excel.Application.

I then try to run a macro named "Run_Report".  This works fine and dandy
under Excel 2000, but with Excel 97, I get an error from my VB application
that states that the macro can not be found.

Any thoughts?

Thanks,

George

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk

George

The "symptomatic of a compile error in the Excel code" was correct.  The
offending code was actually an Enum listing.

So I changed my Enum values to constants, recompiled, and it ran like a
dream under Office 97 Professional.

Now it is bombing under Office 97 Standard.  (sigh)  But it won't go into
the de{*filter*} now, it just raises the error about the macro not being found.

Any further suggestions?

Thanks,

George

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk