can't find project or library - error
 

I inherited a spreadsheet. If I enter any numbers or formulas in any cell, I
get a "can't find project or library" error. I understand this is related to
VBA, but I cannot find a description of why I am seeing this behavior, or how
to enter formula without the error without shutting off anything that would
effect the existing spreadsheet. Perhaps a brief description of how VBA works
would also help.

can't find project or library - error
 

This is usually because the spreadsheet is trying to reference a library that
has not yet been installed on your computer.


1. touch ALT+F11

This opens the VBA window

2. pull-down:
Tools Referemces...

This opens up a long list of references. Look for the missing one.
Then get installation instructions
--
Gary's Student
gsnu200701


"Chris T-M" wrote:

I inherited a spreadsheet. If I enter any numbers or formulas in any cell, I
get a "can't find project or library" error. I understand this is related to
VBA, but I cannot find a description of why I am seeing this behavior, or how
to enter formula without the error without shutting off anything that would
effect the existing spreadsheet. Perhaps a brief description of how VBA works
would also help.

can't find project or library - error
 

There are several pages of non-checked items, but nothing indicates a
'missing' reference. Any additional thoughts?

"Gary''s Student" wrote:

This is usually because the spreadsheet is trying to reference a library that
has not yet been installed on your computer.


1. touch ALT+F11

This opens the VBA window

2. pull-down:
Tools Referemces...

This opens up a long list of references. Look for the missing one.
Then get installation instructions
--
Gary's Student
gsnu200701


"Chris T-M" wrote:

I inherited a spreadsheet. If I enter any numbers or formulas in any cell, I
get a "can't find project or library" error. I understand this is related to
VBA, but I cannot find a description of why I am seeing this behavior, or how
to enter formula without the error without shutting off anything that would
effect the existing spreadsheet. Perhaps a brief description of how VBA works
would also help.

can't find project or library - error
 

Create a new post in Excel Programming. Perhaps they can help.
--
Gary's Student
gsnu200701


"Chris T-M" wrote:

There are several pages of non-checked items, but nothing indicates a
'missing' reference. Any additional thoughts?

"Gary''s Student" wrote:

This is usually because the spreadsheet is trying to reference a library that
has not yet been installed on your computer.


1. touch ALT+F11

This opens the VBA window

2. pull-down:
Tools Referemces...

This opens up a long list of references. Look for the missing one.
Then get installation instructions
--
Gary's Student
gsnu200701


"Chris T-M" wrote:

I inherited a spreadsheet. If I enter any numbers or formulas in any cell, I
get a "can't find project or library" error. I understand this is related to
VBA, but I cannot find a description of why I am seeing this behavior, or how
to enter formula without the error without shutting off anything that would
effect the existing spreadsheet. Perhaps a brief description of how VBA works
would also help.

can't find project or library - error
 

I would first try cleaning out VBA's internal code storage. After lots of
editing, VBA doesn't fully clean up after itself, and lots of junk code
remains inside VBA's internal code storage areas. This entails Exporting all
modules to text files, Removing all modules from the project, thus purging
VBA's code storage areas, and then Importing the text files. This is all
automated down to a single mouse click with Rob Bovey's free Code Cleaner
add-in, available for download at
http://www.appspro.com/Utilities/CodeCleaner.htm. . Rob's Code Cleaner is
one of the "must haves" for serious Excel developers.

If that doesn't work, then next thing I'd do would be to make Excel
re-register itself and all of its components with Windows. Close Excel and
all other programs, and then go to the Windows Start menu, choose Run and
enter
Excel.exe /unregserver
Then repeat with
Excel.exe /regserver

This will cause Excel to restore itself and all of its related components
back to "factory defaults". You may need to enter the full path name of
Excel in the Run dialog. E.g., including quotes,
"C:\Program Files\Microsoft Office\Office\Excel.exe" /unregserver

Of course, your path to Excel may be different.

Now try starting Excel in the normal manner.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Chris T-M" wrote in message
...
There are several pages of non-checked items, but nothing indicates a
'missing' reference. Any additional thoughts?

"Gary''s Student" wrote:

This is usually because the spreadsheet is trying to reference a library
that
has not yet been installed on your computer.


1. touch ALT+F11

This opens the VBA window

2. pull-down:
Tools Referemces...

This opens up a long list of references. Look for the missing one.
Then get installation instructions
--
Gary's Student
gsnu200701


"Chris T-M" wrote:

I inherited a spreadsheet. If I enter any numbers or formulas in any
cell, I
get a "can't find project or library" error. I understand this is
related to
VBA, but I cannot find a description of why I am seeing this behavior,
or how
to enter formula without the error without shutting off anything that
would
effect the existing spreadsheet. Perhaps a brief description of how VBA
works
would also help.