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?

My guess is, open only that workbook, then after you get the error, if you
go into Tools=References with that workbook as the active project, you will
find a reference shown as MISSING. This will be the source of the problem
and have nothing to do with the Environ function. If you clear up this
missing reference, then you should be OK.

--
Regards,
Tom Ogilvy

DJ wrote in message
...
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?

....dunno if you'll get this but...
MANY THANKS TOM
problem solved.

-----Original Message-----
My guess is, open only that workbook, then after you get
the error, if you
go into Tools=References with that workbook as the
active project, you will
find a reference shown as MISSING. This will be the
source of the problem
and have nothing to do with the Environ function. If
you clear up this
missing reference, then you should be OK.

--
Regards,
Tom Ogilvy

DJ wrote in message
...
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?


.