Workbook path

N

nc

Hi

How can I return the full path of a template using VBA
and login name of windows XP using VBA?


Thanks
 
J

Jim Rech

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
| Hi
|
| How can I return the full path of a template using VBA
| and login name of windows XP using VBA?
|
|
| Thanks
 
Top