Return path

[mdmackillop]

Does anyone have a bit of code to return the path to "Desktop" and "My Documents" etc. for each User, that could be used in a string to create a SaveAs path?

[Jacob Hilderbrand]

This Kb Entry (http://www.vbaexpress.com/kb/getarticle.php?kb_id=216) shows how to get the Desktop path. You can use the same method to get the My Documents folder as well.

[mdmackillop]

Thanks Jake,

And look who approved it!
:blush footinmout

[Jacob Hilderbrand]

You're Welcome :beerchug:

Take Care