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!

Run/execute VBS and pass arguments
 

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" wrote in message
...
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!

Run/execute VBS and pass arguments
 

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!

Run/execute VBS and pass arguments
 

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!