Save with variable users

[itatkmc]

First, thanks in advance for any help you can offer, and second I’m a newbie so here it goes I have code that pulls a file, the user can then modify this file. However I have “hard-coded” the destination that it saves and opens this file from. Now several different users will need to edit, and save this file, so my question comes…How can I make the “JohnD” in C:\Documents and Settings\JohnD\Desktop\Scrap\scrape05.xls a variable so that if the file is moved to a different machine the code will not error out.

[sbakker]

You could use something like
strFileName = "C:\Documents and Settings\" & Application.UserName & "\Desktop\Scrap\scrape05.xls"