Environ Library Not Working on Excel 2000

[Stefan_B]

Hello,

I'm attempting to execute the following line on Excel 2000 and I'm receiving
the error message:

'Compile Error: Can't find project or library'

The code I'm attempting to execute is:

Username = Environ ("Username")

Does anyone have any ideas? The code works in Excel 2003, which is a bit
weird.

Many Thanks,
Stefan.

 

[keepITcool]

it's a standard vba function.
this may be indicative of an (unrelated) reference that's missing.

check tools/references for activated references which have "MISSING"




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


Stefan_B wrote :

 

[Harald Staff]

Hi Stefan

No that is not weird. There are things in Excel 2003 that one couldn't even
imagine back when Excel 2000 was made, you can't expect her to handle those.
Always develop in the oldest version, or you are working blindfolded.

The error is usually a wrong reference. In the VB editor, Tools >
References, if you find some marked Missing, unselect those.

ENVIRON is OS dependant. It works very different in the Windows 9x family
from the Windows NT family and shouldn't therefore be used for
cross-platform applications.

HTH. Best wishes Harald