Excel - vbp file corruption

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Excel - vbp file corruption

  1. #1
    New Member
    Join Date
    Jul 2003
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Excel - vbp file corruption



    I AM EXASPERATED BY THE BELOW PROBLEM. I HAVE REINSTALLED EXCEL
    TO NO AVAIL. IF ANYONE CAN ASSIST WITH STEP-BY-STEP DIRECTIONS,
    IT WOULD BE APPRECIATED. EXCEL ITSELF WORKS FINE, AND I CAN BUILD
    OTHER WORKSHEETS. I JUST NEED TO ACCESS THIS PARTICULAR DOCUMENT, WHICH IS IMPORTANT.

    THANKS!

    I have a MS Excel scheduling file that I update regularly. Excel is working fine, but I cannot open the worksheet
    because a window appears, entitled Microsoft Visual Basic.

    In that error window it says:

    "The .VBP file for this project contains an invalid or corrupt library references ID."

    When I continue on, it says that the following file cannot be found.

    "C:\PROGRAM FILES\COMMON FILES\MICROSOFT SHARED\VBA/VEenLR3.HLP file" It says to
    check to see if it exists, and that if not it has to be reinstalled.


    When you save a project for which a reference has been selected from the References dialog box, an entry is made in the project's .vbp file (called the .mak file in earlier versions of Visual Basic). For example, the entry for a data access object is:

    Reference=*\G{00025E01-0000-0000-C000-000000000046}#0.0#0#C:\WINDOWS\SYSTEM\DAO2516.DLL#Microsoft
    DAO 2.5 Object Library

    [b]To continue on, here's what comes up on the Help menu.....

    This error occurs when such a reference has been edited or corrupted. This error has the following cause and solution:

    A reference in the .vbp file has become invalid.

    Delete the incorrect line from the .vbp file and check the appropriate object library in the References dialog box from the Tools menu. Then save the project, and the correct information will be entered in the .vbp file.

    For additional information, select the item in question and press F1.

  2. #2
    MrExcel MVP DonkeyOte's Avatar
    Join Date
    Sep 2002
    Location
    Suffolk, UK
    Posts
    9,118
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel - vbp file corruption

    this may irritate you ( ) but have you checked to see if indeed this reference exists in the given location? Also, just go through the references dialog box in VBE to see if there are any other libraries that are "ticked" but have : MISSING ...
    Does my a$$ look big in this picture ?

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

DMCA.com