Thanks, Doug. You're probably right about user profile locations, so I'll
make use of that article. Thanks again!
"Douglas J. Steele" wrote:
[Quoted Text] > strFolder = "C:\Documents and Settings\" & Environ("userprofile") & > "\Desktop" > > Having said that, are you SURE that's what you want? On my machine, > userprofile includes C:\Documents and Settings (plus there's always a chance > someone may have his/her profile in a different location). For a far more > reliable approach, see http://www.mvps.org/access/api/api0054.htm at "The > Access Web" > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele> (no e-mails, please!) > > > "tminn" <tminn[ at ]discussions.microsoft.com> wrote in message > news:C8807713-6561-4741-9745-09490050261A[ at ]microsoft.com... > > I'm trying to reference the current Window's user's desktop with some > > code; I > > am using the following: > > > > C:\Documents and Settings\%userprofile%\Desktop > > > > When I run the code I get a "Path not Found" message. Just to test, I > > took > > out "%userprofile%" and inserted the actual user name and the code ran > > fine, > > so I'm almost positive that that's the problem. Is that not the correct > > way > > to reference the current user's profle? Any help would be appreciated. > > > > > |