Is there a way to find out the Operating System on a workstation through VBA code.

I am using other exe files of the operating system (like notepad.exe). Different operating system has this file in different locations. How can I find out the OS of the workstation running Excel through VBA code.?

Any help is appreciated.

Thank you

Mohan wrote:

Is there a way to find out the Operating System on a workstation through VBA code.

I am using other exe files of the operating system (like notepad.exe). Different operating system has this file in different locations. How can I find out the OS of the workstation running Excel through VBA code.?

Excel.Parent.OperatingSystem

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.

Mohan,

Use

Application.OperatingSystem



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Mohan" wrote in message
...

Is there a way to find out the Operating System on a
workstation through VBA code.

I am using other exe files of the operating system (like
notepad.exe). Different operating system has this file in
different locations. How can I find out the OS of the
workstation running Excel through VBA code.?

Any help is appreciated.

Thank you

Hi Mohan;
May be:
MsgBox Environ(21) or MsgBox Environ("windir")

MP

"Mohan" a écrit dans le message de
...

Is there a way to find out the Operating System on a workstation through
VBA code.

I am using other exe files of the operating system (like notepad.exe).
Different operating system has this file in different locations. How can I
find out the OS of the workstation running Excel through VBA code.?

Any help is appreciated.

Thank you

? application.OperatingSystem
Windows (32-bit) NT 5.00

--
Regards,
Tom Ogilvy

"Mohan" wrote in message
...

Is there a way to find out the Operating System on a workstation through
VBA code.

I am using other exe files of the operating system (like notepad.exe).
Different operating system has this file in different locations. How can I
find out the OS of the workstation running Excel through VBA code.?

Any help is appreciated.

Thank you

Thank you .. It worke

----- Tom Ogilvy wrote: ----

? application.OperatingSyste
Windows (32-bit) NT 5.0

--
Regards
Tom Ogilv

"Mohan" wrote in messag
..
Is there a way to find out the Operating System on a workstation throug
VBA code
I am using other exe files of the operating system (like notepad.exe)
Different operating system has this file in different locations. How can
find out the OS of the workstation running Excel through VBA code.
Any help is appreciated
Thank yo