Mandy_
asked on
Create Powershell script from excel
hi folks
i like to create a powershell script with multiple lines as you can see in the excel picture above.
How can i write this cells with powershell code from excel to a ps1 file?
Then i like to call this ps1 from excel to execute embedded in vbs code
LaunchPowerShell.VBS
Set objShell = CreateObject("Wscript.shel
objShell.run("powershell -noexit -file c:\fso\CleanupFiles.ps1")
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hi ,
yes what i want is this
Topic
i'm still not have time enough to try different setups. how could i start all commands in only one ps session (EWS) ?
yes what i want is this
Topic
i'm still not have time enough to try different setups. how could i start all commands in only one ps session (EWS) ?
btw, wouldn't be easier to simple copy all the commands from the excel and create the PS file yourself?