• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 216
  • Last Modified:

How to run DOS program with output

I have a command line application that lists various attributes of Active Directory users. I can run the application from the command line and have the results output to a text file, but when trying via VB there is no output.

Here is the code -

Private Sub Command1_Click()

Shell("c:\ListUser -d -t > C:\Results.txt", vbNormalFocus)
    MsgBox "Done"

End sub

The application runs but just no output. Any help would be greatly appreciated

The d switch represents the disabled users and the t switch formats the output into tab delimited. I want to avoid having to use any batch files and just run the app directly from VB.
0
newsquest
Asked:
newsquest
  • 2
  • 2
1 Solution
 
justchat_1Commented:
Use shellexecute:
http://trixar.com/~makai/shellex.htm

and listuser should have a file extension...
0
 
[ fanpages ]IT Services ConsultantCommented:
Or...

Call Shell(Environ$("ComSpec") & " /c c:\ListUser -d -t > C:\Results.txt", vbNormalFocus)

BFN,

fp.
0
 
tguezCommented:
The problem is that the commnd "> txt.out" is a dos command line command.  Then shell is not a command line.  It just run programs.  So I don't know if what the user suggested above wrote works.

But if that does not work, try type your command into *.bat file.  Then use the shell command to run the *.bat file.  This should work just fine.  The only side effect that you will see a command window open and flash and close.  So you might want to specific minimize option when you execute the shell command, so the user will not see a flashing screen.

Tomer
0
 
justchat_1Commented:
The shell is running a program, the command interpreter, and passing his program as an argument...

The code specified above works perfectly, give it a try...
0
 
[ fanpages ]IT Services ConsultantCommented:
Hi Dan,

Please consider a split of points between all contributing experts.

Thanks.

BFN,

fp.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now