saving file based on network login

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Excel spreadsheet which will be used by many users across our network. I would like to have the spreadsheet save to a user's My Documents folder in Windows 2000 (C:\Documents and Settings\"UserName"\My Documents). The "UserName" is the person's network ID, the folder being set up when they initially log on to the Network. Is there any way inside an Excel macro that I can get this Network ID/User name? I tried Application.UserName but that seems to return the generic computer owner, and not the name of the person logged on to the Network. Once I have the Network ID I can put that variable in the file save path so all users can use the same spreadsheet to do their saves

Thanks!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

File owner attributes through Excel VBA 4
Network file attributes 1
Saving files in one place 2
Wifi Network Issue 0
Creating a path to save a file 5
Force Save Folder Location on Network 2
Why is file suddenly "Read Only"? 3
Saving a Word document as PDF from en Excel macro 2

Back
Top