Hello Forum Pals:

I have an app running in Excel 2002 and 2003 without problems, but when
used in PCs with Excel 2000. The app breaks in some functions already
working. The functions are : Environ and Format. I changed the Format
to FormatPercentage and seems be recognizable by the Excel 2000. But I
'm still having troubles with Environ function.

Why do you think these functions are not working in Excel 2000 when
they work in Excel 2003?

Could you give a hint on how to proceed with this trouble?


Any help will be welcomed

Regards

Jose Luis


--
jose luis
------------------------------------------------------------------------
jose luis's Profile: http://www.excelforum.com/member.php...o&userid=13312
View this thread: http://www.excelforum.com/showthread...hreadid=392641

Format has worked since xl5

Environ has worked at least since xl97.

Perhaps you have a missing reference in tools references.

--
Regards,
Tom Ogilvy

"jose luis" wrote
in message ...

Hello Forum Pals:

I have an app running in Excel 2002 and 2003 without problems, but when
used in PCs with Excel 2000. The app breaks in some functions already
working. The functions are : Environ and Format. I changed the Format
to FormatPercentage and seems be recognizable by the Excel 2000. But I
'm still having troubles with Environ function.

Why do you think these functions are not working in Excel 2000 when
they work in Excel 2003?

Could you give a hint on how to proceed with this trouble?


Any help will be welcomed

Regards

Jose Luis


--
jose luis
------------------------------------------------------------------------
jose luis's Profile:
http://www.excelforum.com/member.php...o&userid=13312
View this thread: http://www.excelforum.com/showthread...hreadid=392641

Thanks Tom,

I will check References in Tools in VBA Editor. The strange think it's
the rest of the application and functions are working. I found several
Visual Basic for Applications options in the References Menu, each one
with different file location, I'll try some of them to see if its the
Language or something, because some PC's are running with the system in
english and some in spanish.

Thank you again for your help , I let you know the solution ( if I find
it :) )

Regards

Jose Luis


--
jose luis
------------------------------------------------------------------------
jose luis's Profile: http://www.excelforum.com/member.php...o&userid=13312
View this thread: http://www.excelforum.com/showthread...hreadid=392641

Tom ... Jose Luis again.

I checked the references in diferent PC and found no differences, th
worst part is that now the application is breaking in all kind o
functions: Left, Chr, Environ, Format. In your last reply pointed a
some reference may be missing. The same file from the same sourc
works fine in Excel 2002 or 2003. Just breaks in Excel 2000. Could yo
give me another hint on what to check to put this app to run?

I´ll appreciate any help, cause this is turning like a Demento
(extracts my entusiam and joy :) )

Best regards

Jose Lui

--
jose lui
-----------------------------------------------------------------------
jose luis's Profile: http://www.excelforum.com/member.php...fo&userid=1331
View this thread: http://www.excelforum.com/showthread.php?threadid=39264

I'm with Tom on this.

The problems you describe are typical for xl running when one of
it's referenced dll's is listed as "MISSING".
It then "cracks" on the seemingly unrelated VBA functions.

RECHECK the references on the Xl2000 machine.
WHEN THE PROBLEM FILE IS THE ACTIVE PROJECT.

If you have option explicit at the top of your modules
compiling the project should catch most most problems.
(unless all variables are dimmed as variants..)

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


jose luis wrote :


Tom ... Jose Luis again.

I checked the references in diferent PC and found no differences, the
worst part is that now the application is breaking in all kind of
functions: Left, Chr, Environ, Format. In your last reply pointed at
some reference may be missing. The same file from the same source
works fine in Excel 2002 or 2003. Just breaks in Excel 2000. Could
you give me another hint on what to check to put this app to run?

I´ll appreciate any help, cause this is turning like a Dementor
(extracts my entusiam and joy :) )

Best regards

Jose Luis

Thank you both Tom & keepitcool

Finally i found the error following your sugestions. I was not a
missing reference, it was and ADDED reference called " Ref Edit" turned
on. I looked at the references again as you sugested when i saw that
reference that I didn't met before. I turned off and all went to
normality.

Thanks again for your help, the finger error that surely i made was
causing me headaches.

Best regards

Jose Luis


keepITcool Wrote:
I'm with Tom on this.

The problems you describe are typical for xl running when one of
it's referenced dll's is listed as "MISSING".
It then "cracks" on the seemingly unrelated VBA functions.

RECHECK the references on the Xl2000 machine.
WHEN THE PROBLEM FILE IS THE ACTIVE PROJECT.

If you have option explicit at the top of your modules
compiling the project should catch most most problems.
(unless all variables are dimmed as variants..)

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


jose luis wrote :


Tom ... Jose Luis again.

I checked the references in diferent PC and found no differences,
the
worst part is that now the application is breaking in all kind of
functions: Left, Chr, Environ, Format. In your last reply pointed at
some reference may be missing. The same file from the same source
works fine in Excel 2002 or 2003. Just breaks in Excel 2000. Could
you give me another hint on what to check to put this app to run?

I´ll appreciate any help, cause this is turning like a Dementor
(extracts my entusiam and joy :) )

Best regards

Jose Luis


--
jose luis
------------------------------------------------------------------------
jose luis's Profile: http://www.excelforum.com/member.php...o&userid=13312
View this thread: http://www.excelforum.com/showthread...hreadid=392641

arghh... confusion over "ADDED" and "MISSING"..
excel mumbojumbo may be confusing..

when a reference is added and functioning on one PC.
then opened on another machine (without the referenced dll)

you WILL see it in the list in the References dialog
BUT identified as "MISSING" (possibly localized in your excel version)

happy to see it solved :)


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


jose luis wrote :


Thank you both Tom & keepitcool

Finally i found the error following your sugestions. I was not a
missing reference, it was and ADDED reference called " Ref Edit"
turned on. I looked at the references again as you sugested when i
saw that reference that I didn't met before. I turned off and all
went to normality.

Thanks again for your help, the finger error that surely i made was
causing me headaches.

Best regards

Jose Luis