Excel 2010 VBA Tutorial 63 - Using Shell Command to open a batch file

[kabukijoe]

GOOD LESSONS AND GOOD ENGLISH/ THANK YOU

[alfredzhou]

why I use the same code but return a error . Could you help me? It say error 5, invalid procedure call or parameter

[ranayours]

Thanks for the information. What if I need to fetch the output of the shell command back to excel ? 

[aaronkoh]

good day, this was extremely useful for me. could you kindly share how i could perform the same and passing 5 variables to batchfile.

i am currently only able to pass 1 variable using the following
filepath = " & month

where month is the variable to be passed

This works, but i need to pass more than 1 variable in the filepath

[alevanf]

Is there any way to open a vbscript with this method or any other?

[loopingu]

I have a vba code by which I open the plink for ssh connection using shell command where I can run any command by StdIn.Writeline function except password change command. if I run a change password command I am unable to input the password by StdIn.Writeline function. The command is like "set usr pwd" this command gets executed perfectly and after it executes it asks for "Enter Current Password" here the writeline function fails to input the password. If you can point me to the right direction I would really appreciated your help.

[quangnguyen]

I wrote the same code and ran it on Excel 2015 and it didn't work. is there a difference between notepad and notepad++?

[AlejandroCruzCar]

5, invalid procedure call or parameter

[buijenny]

It's not run in excel 365. How to fix this error? Thanks