[RESOLVED] Attempting to make project work in Spanish Office

[pgag45]

Hey there,

I have an Excel VBA project which was developed in the English Microsoft Excel 2003... however, a user in Mexico is unable to run this code (keeps crashing or giving strange output) in his Spanish Microsoft Office 2003 (which I didn't even know existed) ...

I tried a google for differences between Spanish and English Excel, but didn't get anything out of it... I was going to start changing code to get this to work in the Spanish Office, but the only difference I saw was that I assume "Sheet1" is called "Hoja1" (after a quick google translate). So I changed all Sheet1 to Hoja1.

Unfortunately, I have no way of testing in the Spanish Office.. Would there be any other differences anyone could think of?

Thanks!

[pgag45]

I understand that Sheet1 wouldn't work and would crash with a runtime error...

but I don't understand why they would be getting significantly different output...

[westconn1]

depending what your code is doing there could be several other differences, including toolbar names, and menu items, the most common error for these would be "the member of the collection does not exist" or error 9 subscript out of range, you could trap for errors and allow user input to provide the correct name for the collection item, then save the setting for future use

it is possible someone in the forum with spanish would be prepared to test for you, but like you i do not have

[Siddharth Rout]

Like west suggested you will have to wait till someone who knows spanish can help you or

you can try it your self...

Atleast the basics...

Check this out

http://www.acetools.biz/

[anhn]

Not sure this can give any help.
Below is the listing of 340 Excel-97 function names in English vs Spanish, splitted into 2 posts (170 each).

English           Espagnol
ABS               ABS
ABSREF            REFABS
ACOS              ACOS
ACOSH             ACOSH
ACTIVE.CELL       CELDA.ACTIVA
ADD.BAR           AGREGAR.BARRA
ADD.COMMAND       AGREGAR.COMANDO
ADD.MENU          AGREGAR.MENU
ADD.TOOLBAR       AGREGAR.BARRA.HERRAMIENTAS
ADDRESS           DIRECCION
AND               Y
APP.TITLE         APL.TITULO
AREAS             AREAS
ARGUMENT          ARGUMENTO
ASC               ASC
ASIN              ASENO
ASINH             ASENOH
ATAN              ATAN
ATAN2             ATAN2
ATANH             ATANH
AVEDEV            DESVPROM
AVERAGE           PROMEDIO
BETADIST          DISTR.BETA
BETAINV           DISTR.BETA.INV
BINOMDIST         DISTR.BINOM
CALL              LLAMAR
CALLER            LLAMADOR
CANCEL.KEY        CANCELAR.TECLA
CEILING           MULTIPLO.SUPERIOR
CELL              CELDA
CHAR              CARACTER
CHECK.COMMAND     MARCAR.COMANDO
CHIDIST           DISTR.CHI
CHIINV            PRUEBA.CHI.INV
CHITEST           PRUEBA.CHI
CHOOSE            ELEGIR
CLEAN             LIMPIAR
CODE              CODIGO
COLUMN            COLUMNA
COLUMNS           COLUMNAS
COMBIN            COMBINAT
CONCATENATE       CONCATENAR
CONFIDENCE        INTERVALO.CONFIANZA
CORREL            COEF.DE.CORREL
COS               COS
COSH              COSH
COUNT             CONTAR
COUNTA            CONTARA
COUNTBLANK        CONTAR.BLANCO
COUNTIF           CONTAR.SI
COVAR             COVAR
CREATE.OBJECT     CREAR.OBJETO
CRITBINOM         BINOM.CRIT
CUSTOM.REPEAT     PERSONALIZAR.REPETIR
CUSTOM.UNDO       PERSONALIZAR.DESHACER
DATE              FECHA
DATEDIF           SIFECHA
DATESTRING        CADENA.FECHA
DATEVALUE         FECHANUMERO
DAVERAGE          BDPROMEDIO
DAY               DIA
DAYS360           DIAS360
DB                DB
DBCS              DBCS
DCOUNT            BDCONTAR
DCOUNTA           BDCONTARA
DDB               DDB
DEGREES           GRADOS
DELETE.BAR        ELIMINAR.BARRA
DELETE.COMMAND    ELIMINAR.COMANDO
DELETE.MENU       ELIMINAR.MENU
DELETE.TOOLBAR    ELIMINAR.BARRA.HERRAMIENTAS
DEREF             VALREF
DEVSQ             DESVIA2
DGET              BDEXTRAER
DIALOG.BOX        CUADRO.DE.DIALOGO
DIRECTORY         DIRECTORIO
DMAX              BDMAX
DMIN              BDMIN
DOCUMENTS         DOCUMENTOS
DOLLAR            MONEDA
DPRODUCT          BDPRODUCTO
DSTDEV            BDDESVEST
DSTDEVP           BDDESVESTP
DSUM              BDSUMA
DVAR              BDVAR
DVARP             BDVARP
ECHO              ECHO
ENABLE.COMMAND    HABILITAR.COMANDO
ENABLE.TOOL       HABILITAR.HERRAMIENTA
ERROR             ERROR
ERROR.TYPE        TIPO.DE.ERROR
EVALUATE          EVALUAR
EVEN              REDONDEA.PAR
EXACT             IGUAL
EXEC              EJEC
EXECUTE           EJECUTA
EXP               EXP
EXPONDIST         DISTR.EXP
FACT              FACT
FAUX              FALSO
FCLOSE            CERRARA
FDIST             DISTR.F
FILES             ARCHIVOS
FIND              ENCONTRAR
FINDB             ENCONTRARB
FINV              DISTR.F.INV
FISHER            FISHER
FISHERINV         PRUEBA.FISHER.INV
FIXED             DECIMAL
FLOOR             MULTIPLO.INFERIOR
FOPEN             ABRIRA
FORECAST          PRONOSTICO
FORMULA.CONVERT   FORMULA.CONVERTIR
FPOS              POSICIONA
FREAD             LEERA
FREADLN           LEERALN
FREQUENCY         FRECUENCIA
FSIZE             TAMAÑOA
FTEST             PRUEBA.F
FV                VF
FWRITE            ESCRIBIRA
FWRITELN          ESCRIBIRALN
GAMMADIST         DISTR.GAMMA
GAMMAINV          DISTR.GAMMA.INV
GAMMALN           GAMMA.LN
GEOMEAN           MEDIA.GEOM
GET.BAR           INDICAR.BARRA
GET.CELL          INDICAR.CELDA
GET.CHART.ITEM    INDICAR.ELEMENTO.GRAFICO
GET.DEF           INDICAR.DEF
GET.DOCUMENT      INDICAR.DOCUMENTO
GET.FORMULA       INDICAR.FORMULA
GET.LINK.INFO     INDICAR.INFO.VINCULO
GET.MOVIE         GET.MOVIE
GET.NAME          INDICAR.NOMBRE
GET.NOTE          INDICAR.NOTAS
GET.OBJECT        INDICAR.OBJETO
GET.PIVOT.FIELD   INDICAR.CAMPO.TABLA.DI
GET.PIVOT.ITEM    INDICAR.ELEMENTO.TABLA.DI
GET.PIVOT.TABLE   INDICAR.TABLA.DINAMICA
GET.TOOL          INDICAR.HERRAMIENTA
GET.TOOLBAR       INDICAR.BARRA.HERRAMIENTAS
GET.WINDOW        INDICAR.VENTANA
GET.WORKBOOK      INDICAR.LIBRO
GET.WORKSPACE     INDICAR.AREA.DE.TRABAJO
GOTO              IR.A
GROUP             AGRUPAR
GROWTH            CRECIMIENTO
HALT              DETENER
HARMEAN           MEDIA.ARMO
HELP              AYUDA
HLOOKUP           BUSCARH
HOUR              HORA
HYPGEOMDIST       DISTR.HIPERGEOM
IF                -
INDEX             INDICE
INDIRECT          INDIRECTO
INFO              INFO
INITIATE          INICIAR
INPUT             INTRODUCIR
INT               ENTERO
INTERCEPT         INTERSECCION
IPMT              PAGOINT
IRR               TIR
ISBLANK           ESBLANCO
ISERR             ESERR
ISERROR           ESERROR
ISLOGICAL         ESLOGICO
ISNA              ESNOD

[anhn]

English           Espagnol
ISNONTEXT         ESNOTEXTO
ISNUMBER          ESNUMERO
ISPMT             INT.PAGO.DIR
ISREF             ESREF
ISTEXT            ESTEXTO
KURT              CURTOSIS
LARGE             K.ESIMO.MAYOR
LAST.ERROR        ULTIMO.ERROR
LEFT              IZQUIERDA
LEFTB             IZQUIERDAB
LEN               LARGO
LENB              LARGOB
LINEST            ESTIMACION.LINEAL
LINKS             VINCULOS
LN                LN
LOG               LOG
LOG10             LOG10
LOGEST            ESTIMACION.LOGARITMICA
LOGINV            DISTR.LOG.INV
LOGNORMDIST       DISTR.LOG.NORM
LOOKUP            BUSCAR
LOWER             MINUSC
MATCH             COINCIDIR
MAX               MAX
MDETERM           MDETERM
MEDIAN            MEDIANA
MID               EXTRAE
MIDB              EXTRAE
MIN               MIN
MINUTE            MINUTO
MINVERSE          MINVERSA
MIRR              TIRM
MMULT             MMULT
MOD               RESIDUO
MODE              MODA
MONTH             MES
MOVIE.COMMAND     MOVIE.COMMAND
N                 N
NA                NOD
NAMES             NOMBRES
NEGBINOMDIST      NEGBINOMDIST
NORMDIST          DISTR.NORM
NORMINV           DISTR.NORM.INV
NORMSDIST         DISTR.NORM.ESTAND
NORMSINV          DISTR.NORM.ESTAND.INV
NOT               NO
NOTE              NOTA
NOW               AHORA
NPER              NPER
NPV               VNA
NUMBERSTRING      CADENA.NUMERO
ODD               REDONDEA.IMPAR
OFFSET            DESREF
OPEN.DIALOG       ABRIR.ARCHIVO
OPTIONS.LISTS.GET OPCIONES.INDICAR.LISTAS
OR                O
PAUSE             PAUSA
PEARSON           PEARSON
PERCENTILE        PERCENTIL
PERCENTRANK       RANGO.PERCENTIL
PERMUT            PERMUTACIONES
PI                PI
PIVOT.ADD.DATA    TABLA.DI.ADICIONAR.DATOS
PMT               PAGO
POISSON           POISSON
POKE              TRANSFERIR
POWER             POTENCIA
PPMT              PAGOPRIN
PRESS.TOOL        PRESIONAR.HERRAMIENTA
PROB              PROBABILIDAD
PRODUCT           PRODUCTO
PROPER            NOMPROPIO
PV                VA
QUARTILE          CUARTIL
RADIANS           RADIANES
RAND              ALEATORIO
RANK              JERARQUIA
RATE              TASA
REFTEXT           REFTEXTO
REGISTER          REGISTRAR
REGISTER.ID       ID.REGISTRO
RELREF            REFREL
RENAME.COMMAND    CAMBIAR.NOMBRE.COMANDO
REPLACE           REEMPLAZAR
REPLACEB          REEMPLAZARB
REPT              REPETIR
REQUEST           SOLICITAR
RESET.TOOLBAR     RESTABLECER.BARRA
RESTART           REINICIAR
RESULT            RESULTADO
RESUME            REANUDAR
RIGHT             DERECHA
RIGHTB            DERECHAB
ROMAN             NUMERO.ROMANO
ROUND             REDONDEAR
ROUNDDOWN         REDONDEAR.MENOS
ROUNDUP           REDONDEAR.MAS
ROW               FILA
ROWS              FILAS
RSQ               COEFICIENTE.R2
SAVE.DIALOG       GUARDAR.ARCHIVO
SAVE.TOOLBAR      GUARDAR.BARRA.HERRAMIENTAS
SCENARIO.GET      ESCENARIO.INDICAR
SEARCH            HALLAR
SEARCHB           HALLARB
SECOND            SEGUNDO
SELECTION         SELECCION
SERIES            SERIES
SET.NAME          ESTABLECER.NOMBRE
SET.VALUE         ESTABLECER.VALOR
SHOW.BAR          MOSTRAR.BARRA
SIGN              SIGNO
SIN               SENO
SINH              SENOH
SKEW              COEFICIENTE.ASIMETRIA
SLN               SLN
SLOPE             PENDIENTE
SMALL             K.ESIMO.MENOR
SPELLING.CHECK    REVISION.ORTOGRAFICA
SQRT              RAIZ
STANDARDIZE       NORMALIZACION
STDEV             DESVEST
STDEVP            DESVESTP
STEP              PASO.A.PASO
STEYX             ERROR.TIPICO.XY
SUBSTITUTE        SUSTITUIR
SUBTOTAL          SUBTOTALES
SUM               SUMA
SUMIF             SUMAR.SI
SUMPRODUCT        SUMAPRODUCTO
SUMSQ             SUMA.CUADRADOS
SUMX2MY2          SUMAX2MENOSY2
SUMX2PY2          SUMAX2MASY2
SUMXMY2           SUMAXMENOSY2
SYD               SYD
T                 T
TAN               TAN
TANH              TANH
TDIST             DISTR.T
TERMINATE         TERMINAR
TEXT              TEXTO
TEXT.BOX          CUADRO.DE.TEXTO
TEXTREF           TEXTOREF
TIME              NSHORA
TIMEVALUE         HORANUMERO
TINV              DISTR.T.INV
TODAY             HOY
TRANSPOSE         TRANSPONER
TREND             TENDENCIA
TRIM              ESPACIOS
TRIMMEAN          MEDIA.ACOTADA
TRUNC             TRUNCAR
TTEST             PRUEBA.T
TYPE              TIPO
UNREGISTER        DESREGISTRAR
UPPER             MAYUSC
USDOLLAR          USDOLLAR
VALUE             VALOR
VAR               VAR
VARP              VARP
VDB               DVS
VLOOKUP           BUSCARV
VOLATILE          VOLATIL
VRAI              VERDADERO
WEEKDAY           DIASEM
WEIBULL           DIST.WEIBULL
WINDOW.TITLE      VENTANA.TITULO
WINDOWS           VENTANAS
YEAR              AÑO
ZTEST             PRUEBA.Z

[pgag45]

Awesome.. appreciate the help everyone!

I think I got it working... we'll see from the Mexican tester soon.

[anhn]

What have you done?

[pgag45]

I basically just changed Sheet1 to Hoja1.. After scouring through the code, I really didn't find anything else that would need to be changed, or so I think.

The mexican guy will be testing it today.. so I will find out if it worked or not