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.