Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Workbook path
Hi
How can I return the full path of a template using VBA and login name of windows XP using VBA? Thanks |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Hi Jim
Thanks a lot for your help. -----Original Message----- 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK? | Excel Worksheet Functions | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Unprotect Workbook | Excel Discussion (Misc queries) | |||
make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |