Referencing users desktop??

[steveallany2k6]

I have a file which i have created, it gets data from an excel file which is on a users desktop.
The problem i am having is when i have created the macro it references a below
.SourceDataFile = _
"C:\Documents and Settings\uawesudz\Desktop\DATAfile.xls"

when a different user to uawesudz trys to run the script it doesnt work. how do i make it look on the current users desktop. ie anyone can run it as long as the DATAfile.xls is on there desktop?

Thanks in advance

Steve

[Steffen Thomsen]

Hi,

You can use this

Please Login or Register  to view this content.

[Kyle123]

I'd prefer:

Please Login or Register  to view this content.

Or even better:

Please Login or Register  to view this content.

[steveallany2k6]

so if i have the following piece of code where would i use this in it?

Please Login or Register  to view this content.