sagotianitin
04-09-2013, 01:33 AM
Hi Guys,
I want to know if it is possible to capture the output of a DOS command to
excel using VBA code (Without using a text file to store the output) ?
Exactly what I am trying to do is:
I am running "net users /domain sagotianitin" in CMD. And output of command is:
The request will be processed at a domain control
User name sagotianitin
Full Name NITIN SAGOTIA
comment
Country code 000 (System Default)
Account active Yes
Account expires Never
So, here I want that excel captures the User Name value i.e. "sagotainitin" and paste it on to excel sheet.
Help on this would be appreaciated! :beerchug:
Thank You,
Nitin
I want to know if it is possible to capture the output of a DOS command to
excel using VBA code (Without using a text file to store the output) ?
Exactly what I am trying to do is:
I am running "net users /domain sagotianitin" in CMD. And output of command is:
The request will be processed at a domain control
User name sagotianitin
Full Name NITIN SAGOTIA
comment
Country code 000 (System Default)
Account active Yes
Account expires Never
So, here I want that excel captures the User Name value i.e. "sagotainitin" and paste it on to excel sheet.
Help on this would be appreaciated! :beerchug:
Thank You,
Nitin