SpecialFolders Object

Looks up the most commonly required folders on the computer.

The folder names should be returned without a trailing slash, eg "C:\temp".

Set sp = CreateObject("Toolsack.SpecialFolders")

MsgBox "The users desktop is located at : " & sp.UserDesktop

MsgBox "The windows dir is located at : " & sp.Windows

MsgBox "The temp dir is : " & sp.Temp