Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Compile error (Outlook 98, Excel 98)

    I have an Outlook form that we run that uses Excel spreadsheet and the Access database. This used to work fine until just last week. These are the error that I am getting: MS Visual Basic box - Compile error: Can't find project or library

    The code is as follows and the error is on line 2 (DIM...)
    Sub Mailit()
    Dim objOlook as New Outlook.Applications
    Dim objOMail as MailItem
    Set objOLook = New Outlook.Application
    etc
    etc

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

    Re: Compile error (Outlook 98, Excel 98)

    Outlook.Application<big>s</big> is not valid, remove the final <big>s</big>. Moreover, declaring something as New Outlook.Application AND setting it to New Outlook.Application is overdoing it. You don't need to set it any more if you used New in the declaration.

    If it was just a typo in your post, check Tools | References... (in the Visual Basic Editor) and check if the correct references are still present, and if there are no references beginning with MISSING.

  3. #3
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compile error (Outlook 98, Excel 98)

    Sorry that the S was a typo on my part.

    I just went to a different machine that has Office XP and the application is working fine there. But the problems are still there is I go to MY 98 system. So, I am closing this question and asking again to be upgrade to what 99.8 per cent of the company is using.

  4. #4
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compile error (Outlook 98, Excel 98)

    Also there are no references to MISSING anything.

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

    Re: Compile error (Outlook 98, Excel 98)

    Is there a reference to the Microsoft Outlook 8.5 Object Model or whatever it was called for Outlook 98?

Posting Permissions

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