how to define path to folder "MyDocuments" on user's workstation? (or Desktop)

[#1]

Hello

Does anyone know how to define path to folder "MyDocuments" (or Desktop) on user's workstation?

I use macros to export report in MS Excel. User need to write right path for my app to save export-file, sometimes user made mistake and I get wrong path. So, can I define this path without user?

[Clever_Anjos · Accepted solution]

Use this:

Set WshShell = CreateObject("WScript.Shell")
strDocuments = WshShell.SpecialFolders("MyDocuments")

IMPORTANT: you must give System Access in order this work