Excel - vbp file corruption :: MrExcel Message Board



 FAQFAQ
   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   FavoritesFavorites   StatisticsStatistics 
 RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
Online StoreOnline Store

MrExcel Message Board Forum Index -> Excel Questions

Excel - vbp file corruption
Post new topic   Reply to topic
Last Thread | Next Thread  >   Printable version
  Author    Thread

Thomas G. Domer
Welcome to the Board


Joined: 17 Jul 2003
Posts: 1

Flag: Usa

Status: Offline

 Reply with quote  

Excel - vbp file corruption

icon_help.gif

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.

Post Thu Jul 17, 2003 10:30 pm 
 View user's profile Send private message

lasw10
Board Master
Board  Master


Joined: 07 Sep 2002
Posts: 1936
Location: TCR, London, UK
Flag: England

Status: Offline

 Reply with quote  

Re: Excel - vbp file corruption

this may irritate you ( icon_frown.gif ) 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 ...

Post Sat Jul 19, 2003 7:57 am 
 View user's profile Send private message Send e-mail Visit poster's website
  Display posts from previous:      

MrExcel Message Board Forum Index -> Excel Questions


Forum Jump:
Jump to:  

Post new topic   Reply to topic
Page 1 of 1



Add To Favorites

 


Forum Rules:
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB: 2.0.4 © 2001 phpBB Group

Need help posting your first question? Read how to post

Need extra help ? Couldn't get the answer you needed ? Get a free quote from our Consulting Team

Download Colo's HTML Maker utility for displaying your Excel Worksheet on the board.

Download VB HTML Maker to post your code on the board


Check out our new index to 485 Excel Articles.


Return to MrExcel Consulting

All contents Copyright 1998-2004 by MrExcel.com
If you believe information posted here is from your copyrighted source, notify us per the Terms of Use
Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.