Can system variables be used inside Excel
 

Can the system variables like %HOMEPATH% be used inside of Excel? If so then
how?

Can system variables be used inside Excel
 

You can write your own User Defined Functions that you can use in Excel. For
example place this code in a standard code module

public function HomePath() as string
HomePath = thisworkbook.path
end function

In any cell type =HomePath()

You can also use environ to get system data

public function LoginName() as string
LoginName = environ("UserName")
end function
--
HTH...

Jim Thomlinson


"John F" wrote:

Can the system variables like %HOMEPATH% be used inside of Excel? If so then
how?

Can system variables be used inside Excel
 

Thanks Got it

"Jim Thomlinson" wrote:

You can write your own User Defined Functions that you can use in Excel. For
example place this code in a standard code module

public function HomePath() as string
HomePath = thisworkbook.path
end function

In any cell type =HomePath()

You can also use environ to get system data

public function LoginName() as string
LoginName = environ("UserName")
end function
--
HTH...

Jim Thomlinson


"John F" wrote:

Can the system variables like %HOMEPATH% be used inside of Excel? If so then
how?