Re: Reference User Profile
- From: "Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx>
- Date: Fri, 29 Sep 2006 15:31:16 -0400
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C8807713-6561-4741-9745-09490050261A@xxxxxxxxxxxxxxxx
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.
.
- Prev by Date: Re: populate previous fields
- Next by Date: OT (was: Use VBA to create a graphic from a picture in a table)
- Previous by thread: Implementing Viescas' SendOutlookMsg Module
- Next by thread: RE: Excel add in functions not working when being opened through a
- Index(es):
Relevant Pages
|
