Pass arguments from Userform to Shell func

[ITboy]

I've got a Userform in Excel where by I take in 5 values...Section, date,time,no.of periods and mins(in integer)from textboxes.. When I get this values and click a command button, my program goes thru many processes after which I'm calling a Shell func(NOT in the Form Module but a normal module called ShellFunc). My Shelled program is a perl program that creates txt files. In order to do tat, I need to pass in 5 arguments when running the perl program.How to pass in the values taken from the userform to the Shell function.PLs help.Thanks alot for ur help.

[Joacim Andersson]

Doesn't the Shell function work?

Call Shell("""c:\the path\perl.exe"" arg1 arg2 arg3", vbNormalFocus)

[Frans C]

Does the perl program accepts commandline parameters, or do you have to enter the values after the program started?

[ITboy]

It accepts commandline parameters (5 of them) to create text files.but inmy case I have to capture the Userform values and pass it in a module which has a Shell func..The above code I tried but can't run coz ther's a head but no body or tail..I don't know how to do it..pls help anyone.