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

Use shell function

Shell(pathname[,windowstyle])



"Office_Novice" wrote:

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

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?

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?

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?

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?