I've had a frustrating day trying to solve this puzzle,
hopefully someone here can help (it's probably something
simple that I've overlooked :|

I created a spreadsheet that verifies authority to view
based on the Environ("username") object. It bashes the
string against a range in the worksheet.

The program works great on my computer (win2000) but when
I house it on a server it can't find the Environ object.
(Compile error, can't find object) Here's the catch: on
the same server, in the same folder, there is a different
excel sheet that references Environ("username")
flawlessly. I've dissected the code for the working
program but have gotten nowhere. What am I doing wrong?
Is there some default property for the workbook that I
need to point to a different directory to search for .dll
files or to house it on a server?