Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Upgrade from Access 2000 to Access 2003 problem (Access 2003)

    I upgraded a 2000 db to 2003 recently. When I ran the function below it gave me a complie error on the line Dim ObjXLApp As New Excel.Application. Any thoughts? Thanks.
    Const FIRSTROW = 13

    Dim wsp As Workspace, dbv As DAO.Database, tblResolve As DAO.Recordset
    Dim tblVchs As DAO.Recordset, tblImpTmp As DAO.Recordset
    Dim ObjXLApp As New Excel.Application
    Dim FileToOpen As String, WhereCriteria As String, ImportTemp As String, tmpVch As String
    Dim TotalDupes As Integer, TotalGood As Integer, TotalRejects As Integer
    Dim TotalBlank As Integer, R As Integer, C As Integer
    Dim BadSheet As Boolean, ImpFail As Boolean
    Dim tmp, tmpType, tmpCtr, tmpRsn


    If Forms![Import Block Vouchers]![Import Program] = "0" Then
    MsgBox ("You must select a Program to load.")
    ObjXLApp.Quit 'Exit from MS Excel
    Exit Function
    End If

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Upgrade from Access 2000 to Access 2003 problem (Access 2003)

    It's probably a references problem. Select Tools | References... in the Visual Basic Editor. If there are references starting with MISSING, clear their check boxes, then click OK. Select Tools | References... again, and tick the check box for Microsoft Excel 11.0 Object Library.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgrade from Access 2000 to Access 2003 problem (Access 2003)

    thanks Hans. That did the trick..

Posting Permissions

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