To get the TEMP or TMP folders, use Environ("TEMP") or Environ("TMP")
For My Documents, even though this is a macros group, you're best off using
the API calls illustrated in http://www.yqcomputer.com/
"The Access Web".
Yes, it looks intimidating. However, all you need to do is copy everything
between Code Start and Code End and paste it into a new module (not a class
module nor a module associated with a form or report). When you save the
module, do not name it the same as any of the functions or subs within it.
To be save, call it something like mdlFolders.
Once you've done that, all you need to do to get the My Documents folder,
you'd use fGetSpecialFolderLocation(CSIDL_PERSONAL)
Doug Steele, Microsoft Access MVP
(no private e-mails, please)