View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Windows Operating System

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