>I have been sending excel files to a specific file folder selected by the user using THISFORM.FolderName1.Value=GETDIR()
>The end user is mapping all types of drives and getting the output to ge to strange places.
>
>What I thought might be a good solution is to set the default location the the users desktop. They could use GETDIR() from there
>if they wanted to put is somewhere other than there desktop.

My personal preference is to avoid desktop completely. Have a set of locations below your app, or somewhere below user's My Documents folder, save that as a default location for such things, and keep offering a location from that set (which may have only a single directory :). Keep a MRU list of these.

The "save to desktop" story is, IMO, one of the larger "seemed like a good idea at the time" blunders, cooked up by whoever was thinking of user education in the early days of graphical shells. It may work nice on a demo for something like Windows 3.0, or even 95, but once you see an user with 200 icons on the desktop(*), it doesn't seem like a good idea anymore. Specially with the extensions and datetimes invisible, and funny wallpaper behind it... a mess.

We're supposed to help our users to stay organized.

----
(*) no, I didn't count. Desktop is a directory, number of files can be seen in other ways than Orthodox Christian (counting icons, bah).