need help creating a directory

[mikerock]

need to create a directory in this location. where it says @username it needs to pull the user login name. How do i do this

DirCreate("C:\Documents and Settings\@UserName\Application Data\Microsoft\Signatures\test")

also tried this.

DirCreate("C:\Documents and Settings\%username%\Application Data\Microsoft\Signatures\test")

Edited July 22, 2008 by mikerock

[Jos]

DirCreate("C:\Documents and Settings\" & @UserName & "\Application Data\Microsoft\Signatures\test")

muttley

[mikerock]

Thanks!