Thanks for the Help Joel. Here was my solution, I created a .bat file with
the full path of the script. Then i uesd the Shell function in VBA to launch
the batch file thus running the script.

"Joel" wrote:

A VBA main subroutine (SUB) in VBA cannot have any parameters. The main VBA
sub can call other subroutine and functions passing parameters. The path
must come use other methods then passing parameters

1) You may want to put the script name on the worksheet
2) You can browse for the script using getfilenameopen method
3) You can hard code the filename in the VBA code.
4) You can search for a file name using the DIR() method using a wildcard

Folder = "c:\temp\"
FName = dir(Folder & "*.txt")
do while FName < ""
'enter you code here
FName = dir()
loop



"Office_Novice" wrote:

Any idea how to pass the script's path from VBA to the command line?

"Joel" wrote:

How do you normally run the script?

You provbably have to run the VB and pass the VB apllication the script in a
command line option.

shell("c:\program files\Vb\vb.exe c:\user\myscript")
something like the line above where vb.exe is the application. You need
tospecify in the command line the option for a script input.

"Office_Novice" wrote:

Tryied that it threw a Run Time Error: Invaild procedure


"Joel" wrote:

Use shell function

Shell(pathname[,windowstyle])



"Office_Novice" wrote:

Greetings, Is it possible to launch a script from vba?