The first step is to set up the FileSystemObject you'll use to output to the CSV file, and create the file: Set oFSO = CreateObject('Scripting.FileSystemObject')sFile1 = 'M圜omputerInfo.csv'Set oFile1 = oFSO.CreateTextFile(sFile1, 1) Then we'll output all of this information to a CSV file for easy viewing. In this example we're going to query the system for processor information (family, manufacturer, and number of cores), battery information (description and status), and logical disk information (name, free space remaining, and overall size). We've covered how to use VBA to pull computer information into Excel, but you can do this same thing using a simple VB script outside of Excel. This ensures that Windows will recognize the language your script is written in, and process it properly. WSF extension, and you've also enclosed the code at the beginning with: Īnd close out the code with: WScript.Quit Prepare Your Windows ScriptsĮach of the scripts detailed below will run with just a double click so long as you've named the file with the.

Take a look at the following VB Windows scripts and if you see any you'd like to use, just copy and paste the script into Notepad or other coding notes tool and save it as a WSF file. You just double-click the script, answer a prompt, and the task is done. If you store the following scripts in a common place that's quick to get to when you need it, you can accomplish these tasks in a fraction of the time. But VB scripts are better than batch scripts because they're more flexible.

It's possible to learn how to do all of those individual things the normal way, or do them using batch files.

Visual basic script