Run/execute VBS and pass arguments

[Claud Balls]

Is there a way in VBA to run/execute a visual basic script.

I need to do the following:
Test.vbs arg1 arg2

All help is appreciated.

 

[Bob Phillips]

Do you have to run the VBS script, or could you embed the VBS in VBA (it is
almost identical)?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Claud Balls]

The .vbs file is very large, and I ran across several errors when I
copied the code into a vba macro.

 

[Claud Balls]

I got it working, I used:

Shell ("cscript //nologo H:\Excel\WritePerms.vbs ACTION=SHOW TARGET=" &
ActiveWorkbook.FullName)