How to Use VBScript to Run a PowerShell Script

Anonymous — Wed, 18 Jul 2012 05:00:00 GMT

Summary: Microsoft Scripting Guy, Ed Wilson, shows you that it's easier than you think to use VBScript to run a Windows PowerShell script.

Microsoft Scripting Guy, Ed Wilson, is here. Things are really heating up around here—and I am not just talking about the hot, humid weather down in Charlotte, North Carolina in the United States. First, I am busily getting ready for my trip to Seattle, Washington next week. I will be speaking about using Windows PowerShell 3.0 to manage the remote Windows 8 desktop to a bunch of Microsoft people from all over the world. The event (called TechReady 15) is like TechEd, only it is only for Microsoft employees. Nevertheless, in every other fashion, including the size and scope of the event, it is like TechEd. I really look forward to speaking at this event, because it is an honor to get to speak to so many smart people, and it is a great chance to see my friends from all over the world.

The second thing that is exciting are Windows 8 (which I have been running on my production machine for some time) and Office 15 (which I have just installed on my production machine). It is sooo cool, and is powerful, simple to use, and fun. Often powerful and simple do not go together in the computing world. This time, I think we did it right. The Scripting Wife is absolutely chomping at the bit to get a new slate device. I agreed to get her one for the holidays, but she wants it NOW!

The third thing that is super exciting is Windows PowerShell Saturday on September 15 at the Charlotte Microsoft office. We have just about finalized the schedule, and we have all the speakers lined up. It will be a super cool event. Keep watching, because we will be opening registration very soon, and expect it to sell out within days. We have to limit the attendance to 200 people, so you will want to ensure that you are watching for the announcement. The announcement of the opening of registration will take place on Twitter, then on Facebook on the Scripting Guys Facebook site, and then on the Scripting Guys blog, and finally on the Learn PowerShell page. So this would be a good time to get a twitter account and start following @ScriptingWife and @ScriptingGuys. By the way, I love the Rowi app on Windows 8.

Creating a VBScript to run Windows PowerShell

When creating a permanent WMI event consumer that uses the ActiveScriptEventConsumer WMI class, you need to use VBScript as the script type. This is because ActiveScriptEventConsumer does not know how to run a Windows PowerShell script. This is not a huge problem, however, because writing a VBScript script to launch a Windows PowerShell script is very easy when you know the secrets.

Note This is the third blog in a five part series about monitoring a folder for the creation of files that have leading spaces in the file names. On Monday, I wrote Use PowerShell to Detect and Fix Files with Leading Spaces, and the scripts from that blog will be used today and again on Friday. On Tuesday, I wrote Use PowerShell to Monitor for the Creation of New Files. This blog talks about creating a temporary WMI event to monitor for the creation of files in a particular folder. This query is crucial to Friday’s blog.

There are two methods available from the WshShell Object to launch other programs. These methods are the Exec method and the Run method. For my purpose, I use the Run method. It takes two lines of VBscript code; therefore, I use Notepad to create the script. Remember to save it as a .vbs file. The script is shown here.

LaunchPowerShell.VBS

Set objShell = CreateObject("Wscript.shell")

objShell.run("powershell -noexit -file c:\fso\CleanupFiles.ps1")

The first line of code creates the WshShell object, and it stores the returned object in the objShell variable. This line is shown here.

Set objShell = CreateObject("Wscript.shell")

The second line of code runs the command. The syntax of this command is critical. It is a good idea to use the Start / Run command to practice the syntax before embedding it in the VBScript script. Here is an example of using the Run command to practice the syntax.

If you need to bypass the execution policy, you would add that switch to the command as well. The syntax to bypass the execution policy is shown here.

powershell -executionpolicy bypass -noexit -file c:\fso\helloworld.ps1

It is also possible to run a specific Windows PowerShell command or series of commands from the VBScript script. This technique is shown here.

objShell.run("powershell -noexit -command ""&{0..15 | % {Write-Host -foreground $_ 'Hello World' }}""")

Note Keep in mind that you are writing in VBScript. Therefore, you need to escape the quotation marks with another pair of quotation marks. Also, remember that you use REM to comment out a line, and not the pound sign character (#) that is used in Windows PowerShell.

The CleanupFiles.ps1 script referenced in the VBScript script is the Get-FilesWithLeadingSpaces function from Monday’s blog, Use PowerShell to Detect and Fix Files with Leading Spaces. I removed it from the function and placed it in a file to make it easier to call from within the VBScript script. The CleanupFiles.ps1 file is shown here.

CleanupFiles.ps1

Param(

[string]$path = "c:\test",

[switch]$rename = $true

)

Get-ChildItem -Path $path -Recurse |

foreach-object -Begin {$count = 0} -process {

if($_.name.length -ne $_.name.trim().length)

{

if($rename)

{

Rename-Item -Path $_.fullname -NewName ("{0}{1}{2}" -f `

$_.basename.trim(),$count,$_.extension)

$count++

}

else

{"$($_.basename) contains a leading space"}} }

By using the New-FilesWithLeadingSpaces function from Monday, I create 10 new files with leading spaces in the names in a folder named test. These newly created folders are shown here.

Now, I want to try out my VBScript script to see if I can run it, and cause it to launch the Windows PowerShell script to clean up the folder. I open a command prompt, and drag the VBScript script to the command line. The command prompt is shown here.

When I run the script, a Windows PowerShell console appears, but it does not look like it really did anything. Here is the newly appearing Windows PowerShell console.

But when I go to the c:\test folder, I see that all the files are fixed. This is shown here.

That is all there is to using VBScript to run a Windows PowerShell script. WMI Event Monitoring Week will continue tomorrow when I will talk about using the WMI admin tools to monitor for newly arriving events.

I invite you to follow me on Twitter and Facebook. If you have any questions, send email to me at scripter@microsoft.com, or post your questions on the Official Scripting Guys Forum. See you tomorrow. Until then, peace.

Ed Wilson, Microsoft Scripting Guy

Use Jobs to Run Parallel Queries or Remove Objects from Active Memory

Anonymous — Fri, 14 Jan 2011 06:00:00 GMT

Summary: Learn how to use jobs to run parallel queries, remove objects from active memory, work with text files and use the Get-Member Cmdlet to go behind the scenes of PowerShell commands in this edition of Quick Hits Friday. In this Post: Use Jobs to...(read more)

How Do I Install PowerShell on Windows 7 and Other Questions

Anonymous — Fri, 07 Jan 2011 06:00:00 GMT

Summary: Learn how to install Windows PowerShell on Windows 7, how to detect 32-bit PowerShell, or how to read an offline registry. In this post: Install Windows PowerShell on Windows 7 Detect 32-bit PowerShell Read an Offline Registry Working with Security...(read more)

Scripting Guys Holiday Special

Anonymous — Fri, 17 Dec 2010 06:00:00 GMT

Microsoft Scripting Guy Ed Wilson here. Remember those really cheesy late night commercials? I used to stay up late on weekends watching “The Cool Ghoul” and making fun of really bogus commercials. Evidently, I was not the only one to engage...(read more)

Use PowerShell to Detect Version of Internet Explorer

Anonymous — Fri, 10 Dec 2010 06:00:00 GMT

Summary: Learn how to use Windows PowerShell to detect the version of Internet Explorer that is running on your computer. In this post: Access Environment Variables using a VBS Script Version Control for PowerShell Scripts Detect Internet Explorer Versions...(read more)

Automatically Add Comments in PowerShell, Work with Text Files and Customize Office Communicator

Anonymous — Fri, 19 Nov 2010 06:00:00 GMT

Summary: Learn how to automatically add multiline comments in the Windows PowerShell ISE, how to work with text files in VBScript, and how to customize Microsoft Office Communicator. In this post: Customize Sounds in Office Communicator Work with Text...(read more)

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (10/1/10)

Anonymous — Fri, 01 Oct 2010 05:00:00 GMT

Summary : The Scripting Guys show you how to use functions in Windows PowerShell background jobs, troubleshoot VBScript, and use WMI computer shutdown events. In this post : WMI Computer Shutdown Events Use Functions in Windows PowerShell Background Jobs...(read more)

Quick-Hits Friday: Run VBScript from the PowerShell Console, and Search for Multiple Extensions

Anonymous — Fri, 17 Sep 2010 05:00:00 GMT

Summary : The Microsoft Scripting Guys discuss adding Run As capability to VBScript and using Windows PowerShell to run VBScript. Also discussed: Searching for multiple extensions, and creating a local account and adding it to the local administrators...(read more)

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (9/10/10)

Anonymous — Fri, 10 Sep 2010 05:00:00 GMT

Summary : The Scripting Guys answer questions about Windows Features, and discuss troubleshooting VBScript scripts and Windows PowerShell. In this post : Converting a VBScript Script to a Windows PowerShell Script Using the Add-Windowsfeature Cmdlet to...(read more)

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (8/27/10)

Anonymous — Fri, 27 Aug 2010 05:00:00 GMT

In this post : How Can I Take Script Output and Use It in Other Scripts? Troubleshooting a Script That Reads from Excel Does Windows 7 Recognize VBScript Scripts? Can I Change the Path to the Profile Folder in Windows PowerShell? How Can I Take Script...(read more)

Search results for 'app:weblogs' matching tags 'VBScript' and 'Windows PowerShell'