VB and Access Macros???

[Jimma]

I am a relative newbie and am trying to run a macro from VB6 that will export a table's contents to an Excel spreadsheet. I have Access 2000 on my machine, but the users machines are running '97. The macros work when running on my machine, but I get an Active X error when running on a machine with Acc-97. I want to avoid creating a text file for Importing to Excel, if possible.

Any thoughts would be appreciated.

[lychew]

I think this happens because Access 2000 is using Jet 4.0 Engine and Access 97 is using Jet 3.5. So the macro will not work.