Can't open file: "The .VBP file for this project contains aninvalid or corrupt library references ID

[Michael Levin]

I'm running Microsoft Excel v.X on a Mac with Panther (OS X). An Excel file
which I used a lot now cannot be opened - it says "The .VBP file for this
project contains an invalid or corrupt library references ID". I have no
idea what this is - it's a single file with just 2 sheets in it, and is
fairly simple - no links to outside objects, no graphics, etc. Just a single
file. What can I do to get it opened?? Microsoft Word can read it, but I'd
like to keep working on it in Excel... Thanks in advance!

Mike Levin

 

[JE McGimpsey]

I'm running Microsoft Excel v.X on a Mac with Panther (OS X). An Excel file
which I used a lot now cannot be opened - it says "The .VBP file for this
project contains an invalid or corrupt library references ID". I have no
idea what this is - it's a single file with just 2 sheets in it, and is
fairly simple - no links to outside objects, no graphics, etc. Just a single
file. What can I do to get it opened?? Microsoft Word can read it, but I'd
like to keep working on it in Excel... Thanks in advance!

This is a new one on me. IIRC, .vbp file is the Visual Basic project
file, and should only be useful with a Windows machine that has Visual
Basic loaded.

If you have access to WinXL02/03, they may be able to open it, as they
have some advanced file recovery methods.

I've also had success opening files with OpenOffice

http://www.openoffice.org

which runs on Apple's X11 platform.

 

[Michael Levin]

This is a new one on me. IIRC, .vbp file is the Visual Basic project
file, and should only be useful with a Windows machine that has Visual
Basic loaded.

If you have access to WinXL02/03, they may be able to open it, as they
have some advanced file recovery methods.

good idea. I'll try it on a PC tomorrow...

I've also had success opening files with OpenOffice

http://www.openoffice.org

which runs on Apple's X11 platform.

yep; OpenOffice was able to open it, but didn't keep any of the functions
I defined myself. If there's no way to get Mac Excel to open this thing,
I'll have to cut and paste... Speaking of which, I can no longer get to the
functions! About 4 years ago, in an old version of excel, I defined a couple
of statistics routines, and they are embedded in some of my sheets. I can't
get to them now in the new version of Excel; can anyone tell me how to get
at them? Where, in Excel v.X, do you define new functions you can call in
cells?

Mike

 

[JE McGimpsey]

yep; OpenOffice was able to open it, but didn't keep any of the functions
I defined myself. If there's no way to get Mac Excel to open this thing,
I'll have to cut and paste... Speaking of which, I can no longer get to the
functions! About 4 years ago, in an old version of excel, I defined a couple
of statistics routines, and they are embedded in some of my sheets. I can't
get to them now in the new version of Excel; can anyone tell me how to get
at them? Where, in Excel v.X, do you define new functions you can call in
cells?

In any version of XL, User Defined Functions (UDFs) are stored in
regular code modules (see

http://www.mcgimpsey.com/excel/modules.html#regular

for more info). Type Opt-F11 to enter the Visual Basic Editor (VBE).
Look for the Modules folder in your project (file). The UDFs will be
stored in one or more regular modules.