John
I was able to edit it and change the duplicate name using a HEX editor.
What a bizarre thing to have to do!!

Cheers
Nigel



"jaf" wrote in message
...
That's correct. My mistake. Modules are exported as .bas.
You still should be able to edit & import the file. You have to delete the
original file or you will have two the same name.

--

John

johnf202 at hotmail dot com


"Nigel" wrote in message
...
John,

Thanks for the tip. Exporting the form actually creates two files, .frm
and
.frx
The .frm file has the form code which is editable in notepad. The .frx,
which I suspect has the control information is not editable and is
encoded
in some way.

So its back to the drawing board!

I really don't understand why Excel lets you create duplicate names,
close
the object and then complains when you try to open it again.
Fortunately
the from was not too complex but I would rather not have to do it all
again.

Cheers
Nigel


"jaf" wrote in message
...
Hi Nigel,
I never had the problem so I'm not sure if this will work.

Open your project and right click the form in project explorer.
Choose export form.
Excel will save it with a .bas ext.
Open the .bas file with notepad, revise the control name & save the
file.

Right click the form & this time choose delete.
Answer no to: do you want to save.

Right anywhere in the project explorer and choose import file or do a
fileimport from the menus.
Import the file and save the workbook.


--

John

johnf202 at hotmail dot com


"Nigel" wrote in message
...
I have a userform with a number of controls. When editing the
controls
I
named two items the same. Now I am unable to open and edit the
userform
as
I get the message 'Ambiguous Name detected' How do I fix this ?

Cheers




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet
News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World!
100,000
Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via
Encryption
=---






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet
News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000
Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via
Encryption
=---






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---