View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 292
Default Environ Library Not Working on Excel 2000

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

"Stefan_B" skrev i melding
...
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.