I don't like saving things to the desktop but there are times when it makes
sense. The following lines will give you the path to the desktop on
whatever PC the code is being run.

Const Desktop = &H10&
Set objShell = CreateObject("Shell.Application")
Set objFldrDesk = objShell.Namespace(Desktop)
strDeskPath = objFldrDesk.Self.Path & "\"


Steve Yandl



"Graff" wrote in message
...
Hello,

I'm just finishing up programming my file and i'm stuck. I need to
automatically save this file on Desktop for example but it will be used on
different computers. Directory names will be different. They are all
running
windows OS.
For example:
c:\Documents and settings\User name\Desktop
"User name" folder will be different on every computer. Is there any way
to
point my code to save in "Desktop" folder directly?
Thanks for your help.