Re: $$Excel-Macros$$ Help with saveas file code

2015-08-11 Thread Paul Schreiner
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. 

RE: $$Excel-Macros$$ Help with saveas file code

2015-08-11 Thread gargee singh
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