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?