Run/execute VBS and pass arguments

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.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

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" <[email protected]> wrote in message
news:%[email protected]...
> 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.
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

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


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

I got it working, I used:

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



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!