Thank you for your reply.
The name "Base de Datos" appears in the dropdown but when I select it an
error appears saying it's not a valid name.
The results in the Inmediate Window:

?Range("Database").address
$A$1:$G$3300
?Names("Database").namelocal
Base de datos

The range is correct.

Can I change the namelocal via VBA?

Thanks

Luis Verme


"keepITcool" <xrrcvgpbby@puryyb.ay> escribió en el mensaje
news:xn0e441bpj2vukv000keepitcoolnl@msnews.microsoft.com...
>
>
> yep:
> that looks like a bug as range names cannot have spaces.
>
> can you select it from the dropdown?
>
> if so you have a good chance that
> the english name can be used in code....and only the "local" name is a
> problem..
>
> Try
> ?Range("Database").address
> ?Names("Database").namelocal
>
>
> --
> keepITcool
> | www.XLsupport.com | keepITcool chello nl | amsterdam
>
>
> Luis Verme wrote :
>
>> Hi:
>> In Excel 2003 in Spanish version, when I open a file with "dbf"
>> extension, Excel assigns by default a name to the range which is
>> "Base de Datos". When I try to select this name, a message appears
>> saying there´s an error with the name. Investigating, I saw that the
>> range names must not have blank apaces between the words, so the
>> default name must be "Base_de_Datos" I think this is a bug in the
>> Spanish version of Excel. In the Portuguese version the default name
>> is "Banco_de_dados". I use dbf files in Excel to work with Pivot
>> Tables.
>>
>> Any suggestions
>>
>> Thanks in advance
>>
>> Luis Verme