Creating Names Problem

G

Gio Bacareza

To create a name to represent cells or ranges, I usually just go to the NAME
BOX (upper left corner where the row and column number is found) and simply
type the name. Lately however, when I do that I always get a VBA error
saying "Can't find project or library."

The name is still assigned but getting this dialog box is such a hassle. How
can I get rid of this?

Thanks
 
L

Leo Heuser

Gio

Has your project got a subroutine with the name
you're entering in the Name Box?
 
D

Dave Peterson

Just a guess:

Close excel and reregister it with windows.

Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.
 
G

Gio Bacareza

As suddenly as it appeared, the problem disappears. It disappeared when I
downloaded soap and xml parser libraries. still dont know what and why it
happened in the first place (which is a bummer because i;m really curious)
but then it's solved.

thanks for the help
 
A

Andy Wiggins

Old programmers saying: Things that go away by themselves come back by
themselves.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"



Gio Bacareza said:
As suddenly as it appeared, the problem disappears. It disappeared when I
downloaded soap and xml parser libraries. still dont know what and why it
happened in the first place (which is a bummer because i;m really curious)
but then it's solved.

thanks for the help


Dave Peterson said:
Just a guess:

Close excel and reregister it with windows.

Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.
Click to expand...
to
Click to expand...
 
G

Gio Bacareza

I'm sorry for the premature announcement but the problem crept back again. I
tried your suggestion but the problem is still there...

Gio Bacareza said:
As suddenly as it appeared, the problem disappears. It disappeared when I
downloaded soap and xml parser libraries. still dont know what and why it
happened in the first place (which is a bummer because i;m really curious)
but then it's solved.

thanks for the help


Dave Peterson said:
Just a guess:

Close excel and reregister it with windows.

Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.
Click to expand...
to
Click to expand...
 
D

Dave Peterson

Does it happen with any name you type in or only certain ones?

Maybe you're duplicating the name of an existing sub/function.



Gio said:
I'm sorry for the premature announcement but the problem crept back again. I
tried your suggestion but the problem is still there...
Click to expand...
 
G

Gio Bacareza

all names even random ones like "yudfhsjd" which eliminates the possibility
of duplication. This also happens with blank new files, which should have no
sub functions right? Also I did the unreg and reg procedures. The problem is
still there. This is only on my PC and not on other PCs i;ve tested.
 
A

Andy Wiggins

Just to rule out something ...

Open a blank workbook,
Go into the VBA editor,
Click on Tools > References.

Is there anything there that has MISSING after its name?

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"



Gio Bacareza said:
all names even random ones like "yudfhsjd" which eliminates the possibility
of duplication. This also happens with blank new files, which should have no
sub functions right? Also I did the unreg and reg procedures. The problem is
still there. This is only on my PC and not on other PCs i;ve tested.

Dave Peterson said:
Does it happen with any name you type in or only certain ones?

Maybe you're duplicating the name of an existing sub/function.
Click to expand...
why
it
Click to expand...
just
go
Click to expand...
such
Click to expand...
 
D

Dave Peterson

One more thing to try (but I have no faith in it).

Close excel and reopen it in safe mode.
Windows start button|Run
excel /safe

Open your workbook and test it out.

Starting excel in safe mode means that lots of stuff won't get
loaded--customized toolbars, addins, stuff in xlstart.

Maybe there's something in one of those that interferring with, er, excel's
normal behavior.
 
A

Andy Wiggins

What add-ins have you been using?

Have you used any third party add-ins?

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"



Gio Bacareza said:
all names even random ones like "yudfhsjd" which eliminates the possibility
of duplication. This also happens with blank new files, which should have no
sub functions right? Also I did the unreg and reg procedures. The problem is
still there. This is only on my PC and not on other PCs i;ve tested.

Dave Peterson said:
Does it happen with any name you type in or only certain ones?

Maybe you're duplicating the name of an existing sub/function.
Click to expand...
why
it
Click to expand...
just
go
Click to expand...
such
Click to expand...
 
G

Gio Bacareza

None. (There are lots of unchecked items tho)

Andy Wiggins said:
Just to rule out something ...

Open a blank workbook,
Go into the VBA editor,
Click on Tools > References.

Is there anything there that has MISSING after its name?

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"



Gio Bacareza said:
all names even random ones like "yudfhsjd" which eliminates the possibility
of duplication. This also happens with blank new files, which should
Click to expand...
have
no
sub functions right? Also I did the unreg and reg procedures. The
Click to expand...
problem
Click to expand...
 
G

Gio Bacareza

Add-Ins:
Analysis Toolpak
Solver

3rd Party:
xl2qif


Andy Wiggins said:
What add-ins have you been using?

Have you used any third party add-ins?

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"



Gio Bacareza said:
all names even random ones like "yudfhsjd" which eliminates the possibility
of duplication. This also happens with blank new files, which should
Click to expand...
have
no
sub functions right? Also I did the unreg and reg procedures. The
Click to expand...
problem
Click to expand...
 
A

Andy Wiggins

I'd expect there to be lots of unchecked items.

Okay, that just clears an extremely remote possibility.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
D

Dave Peterson

I've never used it, but I think it converts xl files to QIF (Quicken Interchange
Format (maybe)).

And to the OP:

Did it blow up when you started excel in Safe mode?
 
Top