A couple of thoughts: << If we kept the same code, it would go to a c:\temp directory on the server and one person's report could overwrite another person's report. >>
Unless you're using the same login for each user, I would suspect that there is a way to configure separate temp locations for each user. << We are probably going to create a subdirectory on the network called USERS, with directories under that for each user's login name, and put reports there. We worked with a user on this, and it was fine if the file came up automatically but if the user had to later search through My Computer to find the file, he ended up all over the place which is dangerous. >> If you're going to implement the idea of a "home directory" for each user, you can simply provide a menu option or button "Open My Report Folder" which uses LAUNCH .vUserFolder to open Windows Explorer with the correct directory already opened. -- Larry
