[vanhkhuyen]

Plz help ! I am able to call .exe and .bat program with Shell() function in VB6 program. However, I couldn't do this with my Perl script (.pl). The message that I got was "Invalid function call or argument" . I kept the code the same as when it worked for the .exe and .bat files. The only thing that I changed was .pl (instead of .exe). I tried the work around way by calling .bat file instead of .pl. However, I don't think I will be happy with that if there's maybe a way to deal directly with this Shell() function for my Perl program.

This is my code
sOutPutFile = "C:\Ecsais\MSBHP2FT.FLT"
sExeProgram = "C:\Ecsais\perl MSBHP2FT.pl" & " C:\Ecsais\MSB_OP.FIL"

oFSO.CreateTextFile sOutPutFile, True
lPid = Shell(sExeProgram, vbNormalFocus)

The program failed right here at the last line. Thanks

[Amadeus]

Does that command run correctly when you simply put it in the command line?

[vanhkhuyen]

Yes, it runs fine on the command window manually. As I mentioned, the .bat file is working with Shell(). Thanks

[Amadeus]

Is the word perl in this statement

C:\Ecsais\perl MSBHP2FT.pl

a folder, or the command the invoke the perl environment? If it's the command, shouldn't it be

perl C:\Ecsais\MSBHP2FT.pl

?

[vanhkhuyen]

I tried both with and without the perl command with that Shell(). They're all working by themself on the command line though but not with Shell() function. Thanks