The user name is returned like this:

MsgBox Environ("username")

If you create a new workbook from a template then there is no direct way to
find the path to the template from the new workbook.. If the template was
in the Templates folder this will return that path:
Application.TemplatesPath

--
Jim
"nc" wrote in message
...
| Hi
|
| How can I return the full path of a template using VBA
| and login name of windows XP using VBA?
|
|
| Thanks