OutputTo the user's My Documents directory or to TMP?



New at macros, trying to send a report to file so it will work on any
machine.

I can't figure out how to send to the TMP directory, or to MY
DOCUMENTS without knowing the user's name... what do I put in the
OutputFile box when creating a macro to send it to either the
environment variable TMP (there's one on every machine), or the
user's MyDocuments directory, without hardcoding for a specific user?

Thank you kindly.
.



Relevant Pages