Hi,
I am trying to execute a perl script using ShellAndWait given here. I copied and pasted it to my VBA code. My perl script actually takes in an input. I tried several ways and the DOS window still exits right away or after the input is taken without the perl script completing its tasks.
1. retVal = ShellAndWait("C:\Perl\bin\perl.exe kloku -r", 1000000, vbNormalFocus, PromptUser)
2. retVal = ShellAndWait("C:\Klok2PTK\Data\kloku.bat", 1000000, vbNormalFocus, PromptUser)
I am able to get farther when I place it in a batch file. It actually allows the perl script to prompt me for an input. However, it still closes immediately after I placed an input.
Any help is appreciated. Thanks!
I am trying to execute a perl script using ShellAndWait given here. I copied and pasted it to my VBA code. My perl script actually takes in an input. I tried several ways and the DOS window still exits right away or after the input is taken without the perl script completing its tasks.
1. retVal = ShellAndWait("C:\Perl\bin\perl.exe kloku -r", 1000000, vbNormalFocus, PromptUser)
2. retVal = ShellAndWait("C:\Klok2PTK\Data\kloku.bat", 1000000, vbNormalFocus, PromptUser)
I am able to get farther when I place it in a batch file. It actually allows the perl script to prompt me for an input. However, it still closes immediately after I placed an input.
Any help is appreciated. Thanks!
