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.
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