Find out Operating System

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,

Use

Application.OperatingSystem



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

Mohan said:
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
Click to expand...
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.?
 
? application.OperatingSystem
Windows (32-bit) NT 5.00

--
Regards,
Tom Ogilvy

Mohan said:
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).
Click to expand...
Different operating system has this file in different locations. How can I
find out the OS of the workstation running Excel through VBA code.?
 
Hi Mohan;
May be:
MsgBox Environ(21) or MsgBox Environ("windir")

MP

Mohan said:
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).
Click to expand...
Different operating system has this file in different locations. How can I
find out the OS of the workstation running Excel through VBA code.?
 
Thank you .. It worke

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

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

--
Regards
Tom Ogilv

Different operating system has this file in different locations. How can
find out the OS of the workstation running Excel through VBA code.
 
Mohan said:
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.?
Click to expand...

Excel.Parent.OperatingSystem

Regards,
 
Back
Top