I hope that someone here can help me with this.

Is there a way of identifying which operating system is being used, or where
the Desktop folder is?

The requirement is to save a file to the desktop without worrying about the
username. However, there are users on Windows Server 2003, Windows Server
2008, Windows Vista and Windows XP.

thanks in advance

Carl

Sub WhichOne()
MsgBox (Application.OperatingSystem)
End Sub
--
Gary''s Student - gsnu200832


"Carl Sprake, Oxford, UK" wrote:

I hope that someone here can help me with this.

Is there a way of identifying which operating system is being used, or where
the Desktop folder is?

The requirement is to save a file to the desktop without worrying about the
username. However, there are users on Windows Server 2003, Windows Server
2008, Windows Vista and Windows XP.

thanks in advance

Carl

And for the desktop

MyPath = CreateObject("WScript.Shell").Specialfolders("Desk Top")
msgbox MyPath

Mike

"Carl Sprake, Oxford, UK" wrote:

I hope that someone here can help me with this.

Is there a way of identifying which operating system is being used, or where
the Desktop folder is?

The requirement is to save a file to the desktop without worrying about the
username. However, there are users on Windows Server 2003, Windows Server
2008, Windows Vista and Windows XP.

thanks in advance

Carl