Click here to Skip to main content
15,901,205 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:

I have a VB batch program, while running VB program it will ask the input parameters so I need to give Input and get the result in Excel sheet. Client asking that the same VB program need to create as VBScript file run it using Task scheduler without asking Input parameters but getting output in Excel sheet. How can I do that? Can any one help me?

What I have tried:

I tried like below also, Dim WSHShell
Set WSHShell = Wscript.CreateObject("WScript.Shell")
WSHShell.Run "C:\ACC\BIN\AC23E0.exe MONTHLY", 0, True

But I got only the Command window and Message box but not Exe executed. What can I to do?
Updated 7-Dec-20 0:41am

1 solution

The application you're running will need to support passing the input via command-line parameters. You will need to consult the documentation, source code, or developer to find out how to pass the input via the command line.

If the application doesn't support passing the input via command line parameters, then you won't be able to schedule it.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900