mike.schultz
Board Regular
- Joined
- Sep 22, 2002
- Messages
- 57
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", _
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", _