Does directory exist in French/German Windows installation? If not what is the equivalent?

Hi experts

I have a template currently based on an English installation of Windows 7 that is going to be used in France and Germany.  Part of my code saves files to the following directory (creating if it doesn't exist)

strFilePath = "c:\users\" & Environ("Username") & "\Documents\ANZ Posters"

Does "c:\users\" & Environ("Username") & "\Documents" exist in France and German installations of Windows 7?
If not, does anyone know what the equivalent is?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.


on my German speaking version even if the name displays differently

C:\Benutzer\Username\Eigene Dokumente

 it uses

to save it

Fi69Author Commented:
Uh oh, I didn't hear back from anyone straight away so I've sent it off after googling the web.
will c:\users\username\Dokumente work? That's what I put in.
use best


Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Fi69Author Commented:
Ok, thanks!
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Better to use
strFilePath = Environ("UserProfile") & "\Documents\ANZ Posters"

Open in new window

The "user" folder could have been redirected to a different location.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.