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

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?

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?