Can't Find Project or Library

[Guest]

All of a sudden the =now() results in a 'Can't find project or library'. I've
tried "repairing" Office 2003 to no help. The VBA code has worked like a
champ for months on end.

What gives?

Thanks for any help.

Kim

 

[Dave Patrick]

From any module Tools|References and look for one labeled 'MISSING'

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

 

[Chip Pearson]

Close Excel, then go to the Windows Start Menu choose Run and enter the
following and press OK:

Excel.exe /unregserver

The Run

Excel.exe /regserver


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

 

[Guest]

Chip,

Followed procedure - no effect. My further investigation shows a new excel
file work OK.

The failing workbook has a lot of VBA asscociated with one worksheet. the
failing code is specifically:

If Day([$a$1]) >= 1 And Day([$a$1]) < 5 etc, etc.

cell a1 contains "=now()". The ([$a$1]) is highlighted when I get the error.

Still a mystery.......

Kim

 

[Guest]

Dave,

Couldn't find anything under References window having "MISSING" as part or
as standalone.

My reply to Chip has more detail of what I found.

Thanks for any help.

Kim

From any module Tools|References and look for one labeled 'MISSING'

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

All of a sudden the =now() results in a 'Can't find project or library'.
I've
tried "repairing" Office 2003 to no help. The VBA code has worked like a
champ for months on end.

What gives?

Thanks for any help.

Kim

 

[Chip Pearson]

Kim,

You might try changing your cell references in the code from

[$A$1]
to
Range("A1").Value

It shouldn't make a difference, but when you get weird errors sometimes
changing seemingly unrelated things makes a difference.

Chip,

Followed procedure - no effect. My further investigation shows a new
excel
file work OK.

The failing workbook has a lot of VBA asscociated with one worksheet. the
failing code is specifically:

If Day([$a$1]) >= 1 And Day([$a$1]) < 5 etc, etc.

cell a1 contains "=now()". The ([$a$1]) is highlighted when I get the
error.

Still a mystery.......

Kim

Close Excel, then go to the Windows Start Menu choose Run and enter the
following and press OK:

Excel.exe /unregserver

The Run

Excel.exe /regserver


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

 

[Guest]

Chip,

This is getting wierder (sp?) by the minute.

I followed your instructions -- same effect. Then I tried a few other
things with the same result. I tried:

A blank cell on that worksheet to =NOW()
A blank cell on another worksheet (this workbook has 20 some) to =NOW()
I put a number (pick one) in a blank cell

After each occurance the Error Window came up. I clicked OK and the
References window came up. Scrolling through the libraries, nothing
"Missing". I clicked OK and the cell changed to the date or number as
appropriate.

Kim

Kim,

You might try changing your cell references in the code from

[$A$1]
to
Range("A1").Value

It shouldn't make a difference, but when you get weird errors sometimes
changing seemingly unrelated things makes a difference.

Chip,

Followed procedure - no effect. My further investigation shows a new
excel
file work OK.

The failing workbook has a lot of VBA asscociated with one worksheet. the
failing code is specifically:

If Day([$a$1]) >= 1 And Day([$a$1]) < 5 etc, etc.

cell a1 contains "=now()". The ([$a$1]) is highlighted when I get the
error.

Still a mystery.......

Kim

Close Excel, then go to the Windows Start Menu choose Run and enter the
following and press OK:

Excel.exe /unregserver

The Run

Excel.exe /regserver


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



All of a sudden the =now() results in a 'Can't find project or
library'.
I've
tried "repairing" Office 2003 to no help. The VBA code has worked like
a
champ for months on end.

What gives?

Thanks for any help.

Kim

 

[Guest]

Dave,

My apologizes......on 2nd or 3rd look I found "MISSING" associated with a
program I unloaded days ago (MusicMatch Juke Box). The ActiveX Control
MMJBCTRL was missing.

What it has to to with Excel and my VBA code I'll never know.......

Again, my apologizes.

Dave,

Couldn't find anything under References window having "MISSING" as part or
as standalone.

My reply to Chip has more detail of what I found.

Thanks for any help.

Kim

From any module Tools|References and look for one labeled 'MISSING'

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

All of a sudden the =now() results in a 'Can't find project or library'.
I've
tried "repairing" Office 2003 to no help. The VBA code has worked like a
champ for months on end.

What gives?

Thanks for any help.

Kim

 

[Guest]

Chip,

I did find a "MISSING" reference. It was MMJBCTRL Active x from a program
MusicMatch JukeBox I unloaded several days ago.

What it had to do with Excel I'll never know........

Kim

Chip,

This is getting wierder (sp?) by the minute.

I followed your instructions -- same effect. Then I tried a few other
things with the same result. I tried:

A blank cell on that worksheet to =NOW()
A blank cell on another worksheet (this workbook has 20 some) to =NOW()
I put a number (pick one) in a blank cell

After each occurance the Error Window came up. I clicked OK and the
References window came up. Scrolling through the libraries, nothing
"Missing". I clicked OK and the cell changed to the date or number as
appropriate.

Kim

Kim,

You might try changing your cell references in the code from

[$A$1]
to
Range("A1").Value

It shouldn't make a difference, but when you get weird errors sometimes
changing seemingly unrelated things makes a difference.

Chip,

Followed procedure - no effect. My further investigation shows a new
excel
file work OK.

The failing workbook has a lot of VBA asscociated with one worksheet. the
failing code is specifically:

If Day([$a$1]) >= 1 And Day([$a$1]) < 5 etc, etc.

cell a1 contains "=now()". The ([$a$1]) is highlighted when I get the
error.

Still a mystery.......

Kim

:

Close Excel, then go to the Windows Start Menu choose Run and enter the
following and press OK:

Excel.exe /unregserver

The Run

Excel.exe /regserver


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



All of a sudden the =now() results in a 'Can't find project or
library'.
I've
tried "repairing" Office 2003 to no help. The VBA code has worked like
a
champ for months on end.

What gives?

Thanks for any help.

Kim

 

[Dave Patrick]

No problem. You're welcome.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect