Can't Find Project or Library
 

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

Can't Find Project or Library
 

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

"Kim" wrote:
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

Can't Find Project or Library
 

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)



"Kim" wrote in message
...
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

Can't Find Project or Library
 

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

"Chip Pearson" wrote:

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)



"Kim" wrote in message
...
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

Can't Find Project or Library
 

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

"Dave Patrick" wrote:

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

"Kim" wrote:
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

Can't Find Project or Library
 

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.



"Kim" wrote in message
...
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

"Chip Pearson" wrote:

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)



"Kim" wrote in message
...
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

Can't Find Project or Library
 

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

"Chip Pearson" wrote:

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.



"Kim" wrote in message
...
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

"Chip Pearson" wrote:

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)



"Kim" wrote in message
...
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

Can't Find Project or Library
 

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.

"Kim" wrote:

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

"Dave Patrick" wrote:

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

"Kim" wrote:
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

Can't Find Project or Library
 

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

"Kim" wrote:

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

"Chip Pearson" wrote:

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.



"Kim" wrote in message
...
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

"Chip Pearson" wrote:

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)



"Kim" wrote in message
...
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

Can't Find Project or Library
 

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

"Kim" wrote:
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.