Re: Computer "name"

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

It might be 5 on yours, but not on mine. Should always use the name not
index.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"OssieMac" <OssieMac@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1EDF7086-551F-4F6E-8664-E24B60FABF2C@xxxxxxxxxxxxxxxx
Environ() function gives you lots of these. I think that environ(5) is
computer name.

Use different indexes and test the function

regards,

OssieMac

"D.S." wrote:

Can Excel be programmed to test for my computer's name?

I'd like to create an If/Then statement by looking at the computer name
the
procedure is running on. User name won't work because it's the same user
in
both cases, just running the procedure on different machines.

d.s.





.

Relevant Pages

  • Re: Cell validation
    ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... been entered in place of an alphabet. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Creating Name with variable
    ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... Dim vldFormula As String, sVldName As String ... Thanx & regards, ...
    (microsoft.public.excel.programming)
  • Re: Formula to display the winner
    ... Regards ... (there's no email, no snail mail, but somewhere should be gmail in my ... display the corresponding name from column B in another cell. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How can I this???
    ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... Best Regards ... Shakeel Ahmad ...
    (microsoft.public.excel)
  • Re: Selection.Cells vs Range reference - strange behaviour (using
    ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... parentheses to indicate the parameters to be passed. ... I have a series of subs for formatting text along the lines of ...
    (microsoft.public.excel.programming)