system variables
 

How do I get a system variable (environment variable) to a cell in my
spreadsheet?

Thanks,

Bill V

system variables
 

Most can just be assigned e.g.

Sheets("Sheet1").Range("A1") = ActiveWindow.DisplayWorkbookTabs

Do you have any specific ones in mind?

--
Cheers
Nigel



"William E Voorhees" wrote in message
...
How do I get a system variable (environment variable) to a cell in my
spreadsheet?

Thanks,

Bill V

system variables
 

Range("A1").value = Environ("UserName")

as an example

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"William E Voorhees" wrote in message
...
How do I get a system variable (environment variable) to a cell in my
spreadsheet?

Thanks,

Bill V

system variables
 

Thanks, that works

"Bob Phillips" wrote in message
...
Range("A1").value = Environ("UserName")

as an example

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"William E Voorhees" wrote in message
...
How do I get a system variable (environment variable) to a cell in my
spreadsheet?

Thanks,

Bill V