Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't find project or library | Excel Programming | |||
Cant find project or library | Excel Programming | |||
Can't find project or library | Excel Programming | |||
Can't find project or library | Excel Discussion (Misc queries) | |||
Cant find project or library | Excel Programming |