Results 1 to 2 of 2

Thread: VB and Access Macros???

  1. May 4th, 2000, 07:12 AM #1
    Jimma
    Jimma is offline

    Thread Starter
    New Member
    Join Date
    May 2000
    Posts
    3

    Question

    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.
    Reply With Quote Reply With Quote
  2. May 4th, 2000, 01:21 PM #2
    lychew
    lychew is offline
    Lively Member
    Join Date
    Aug 1999
    Posts
    89
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width