Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Sep 2001
    Stuck at work..., Missouri, USA
    Thanked 0 Times in 0 Posts

    Convert Access 2000 VBA to Access 2003 (2000/2003)

    I wrote some VBA to open an Excel file and import its contents into a table for a friend.

    She used to have Access 2000 but now has 2003 & the code is throwing out all sorts of odd errors.

    Is there anyone who can assist me in converting the code to work in Access 2003? I don't have that version.

    The code is attached.

    Attached Files Attached Files
    <font face="Comic Sans MS">Morgan Erickson</font face=comic>
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>-From <img src=/S/flags/Colorado.gif border=0 alt=Colorado width=30 height=18> but living in <img src=/S/flags/Missouri.gif border=0 alt=Missouri width=30 height=18>...and working in Kansas.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Convert Access 2000 VBA to Access 2003 (2000/2003)

    The only thing I can think of offhand is to check references. This MUST be done on the PC with Office 2003.
    - Activate the Visual Basic Editor.
    - Select Tools | References...
    - If there are references starting with MISSING, write down which ones they are, then clear their check boxes.
    - Make sure that there is a reference to the Microsoft Excel 11.0 Object Library (its check box must be ticked.)
    - Click OK.
    - Select Debug | Compile <projectname>
    If there are still error messages, please write them down and post them, otherwise it will be impossible to assist further.

Posting Permissions

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