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