finding the cuurent users desktop

[mike.schultz]

I have a routine that imports a text file from the users desktop.
is there a way to capture the the users name or just find the active dest top reguardless to who is logged on to the machine?

here is my current code....

With ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;C:\Documents and Settings\MJS2449\Desktop\SFC.txt", _

 

[Oaktree]

Try Application.UserName

edit: Hey, Smitty!

 

[Smitty]

I tend to try to use the All Users desktop. Then you don't have to test for user name.

Smitty

(Heya Matt!)