Using VBA, how do I determine where the Current users Application Data folder is?
The FileSystemObjects special folders only knows about 3 folders
Specifically, I need a Word Macro to copy a file to the a folder under the Application Data folder.
e.g. In VB.Net I can use
My.Computer.FileSystem.SpecialDirectories.CurrentUserApplicationData to do this
You can use
Environ("AppData") to get this path. Environ will pull any system variable, which can be found by using the
set command at the DOS prompt.