Creating Names Problem

  • Thread starter Thread starter Gio Bacareza
  • Start date Start date
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
 
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.
 
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
 
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...
 
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...
 
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...
 
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.
 
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...
 
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.
 
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...
 
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...
 
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...
 
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"
 
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?
 
Yes, xl2qif converts xl files to qif. i use this to convert e-statements,
not supported by Money, to QIF so I can import to Money. (Note to MS
developers: it would be great to have a direct and well-integrated XL-Money
tool out there, dont you think so?)

Anyways, I did safe mode and the problem disappeared.

also, after having removed xl2qif, the problem disappeared. this obviously
points the finger to xl2qif but I cant remove it because i need it.

I'm at a loss guys. Seems that I cant have my cake and eat it too. But I
think there's a solution here that will let me have my cake and eat it too.
Help guys!

thanks
 
Back
Top