VBA code to get path to user's My Documents folder

[DraNoel]

I have a Project 2007 VBA script that needs to find the full path to the
current user's My Documents folder. I know this is a simple task in VB.NET
(just reference the MyDocuments property in My.Computer.FileSystem), but is
there a straightforward way to find the path in a VBA script? Thanks.

 

[Rod Gill]

Unfortunately not.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Seawolf]

Chip Pearson has some really good example code on his consulting website :
http://www.cpearson.com/excel/SpecialFolders.aspx.

 

[DraNoel]

Seawolf, thanks for the information. My colleague referred me to another
blog site,
http://www.dailydoseofexcel.com/archives/2009/02/26/get-the-path-to-my-documents-in-vba/.
They suggested an approach using Wxcript, and so far it appears to be
working.