Dear Paul,
Thank you for the clarification, it is great help.
I am now able to make it work for various users.
Thanks a ton.
gargeeDate: Tue, 11 Aug 2015 12:41:11 +
From: schreiner_p...@att.net
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help with saveas file code
The
The user's "My Documents" folder is USUALLY set up in the C:\users\useridfolder.
There's several ways of getting the login account name, but I think something
like:
MyDocsPath = Environ("USERPROFILE") & "\My Documents"
should give you the path to the user's My Documents folder.
Paul--
