Using Access 2003 macros and OutputTo; can't output into the user's My Documents directory
- From: John Bartley K7AAY <john.bartley@xxxxxxxxx>
- Date: Tue, 22 Jan 2008 10:27:05 -0800 (PST)
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 $TEMP or $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 the directories
specified by the system variables $TEMP or $TMP (there's one on every
machine, either will do), or the user's MyDocuments directory, without
hardcoding for a specific user?
Been hacking away at this for a while and am stymied.
Thank you kindly.
.
- Follow-Ups:
- Re: Using Access 2003 macros and OutputTo; can't output into the user's My Documents directory
- From: Douglas J. Steele
- Re: Using Access 2003 macros and OutputTo; can't output into the user's My Documents directory
- References:
- OutputTo the user's My Documents directory
- From: John Bartley K7AAY
- OutputTo the user's My Documents directory
- Prev by Date: Re: Wrong Calculations
- Next by Date: Re: OpenArgs in OpenForm macro
- Previous by thread: OutputTo the user's My Documents directory
- Next by thread: Re: Using Access 2003 macros and OutputTo; can't output into the user's My Documents directory
- Index(es):
Relevant Pages
|
