Referencing A User's My Documents in VBA

[Jeff G]

All -

I'm creating a form that exports a Report to a PDF. I'd like to have it set
up in VBA so that the report would go to the current user's My Documents
folder rather than to a static folder (primarily due to multiuser problems
in Termial Services).

Is there a way to code in the My Documents reference?

Thanks.

Jeff

 

[Albert D. Kallal]

All -

I'm creating a form that exports a Report to a PDF. I'd like to have it
set up in VBA so that the report would go to the current user's My
Documents folder rather than to a static folder (primarily due to
multiuser problems in Termial Services).

Is there a way to code in the My Documents reference?

Thanks.

Jeff

Here:

http://www.mvps.org/access/api/api0054.htm