Scripting Blog

A place to learn about PowerShell and share stories of automation

ActiveX Data Objects (ADO) - Scripting Blog

Hey, Scripting Guy! Weekend Scripter: Using the Windows Search Index to Find Specific Files

May 30, 2010 May 30, 2010 05/30/10
ScriptingGuy1
  Microsoft Scripting Guy Ed Wilson here. One of the cool things about using Windows PowerShell is the different objects with which you can interact. Windows Search is an example of this. By using ADO, you can query the Windows Search index and retrieve information about files. This technique can have some very interesting possibilities...

Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (04/03/09)

April 4, 2009 Apr 4, 2009 04/4/09
ScriptingGuy1
Troubleshooting the Application of Two WMI Classes   Hey, Scripting Guy! The examples produced from the "Scriptomatic Version 2.0 by The Microsoft Scripting Guys" for the entries Win32_ServiceSpecification and Win32_ServiceControl both return error 0x80041002 under Windows Server 2003. I can't find another WMI class that exposes the ...

Hey, Scripting Guy! How Can I Write to Excel Without Using Excel?

September 16, 2008 Sep 16, 2008 09/16/08
ScriptingGuy1
Hey, Scripting Guy! I need to be able to write information to an Excel file. I do not want to install Microsoft Office Excel on my server, but the spreadsheet format is a nice way to store information. I can then give it to my pointy-headed boss, and he can create pivot tables, charts, or whatever exactly it is he does all day. Basically, ...

Hey, Scripting Guy! How Can I Read from Excel Without Using Excel?

September 12, 2008 Sep 12, 2008 09/12/08
ScriptingGuy1
Hey, Scripting Guy! I have an Microsoft Office Excel spreadsheet with server names in it, and I would like to be able to use this in a Windows PowerShell script. The thing is, I do not have Microsoft Office or Excel installed on the server. How can I use this spread sheet without installing Office on my server (which I understand is ...

Hey, Scripting Guy! How Can I Sort Digital Files By the Date Each Picture Was Taken?

May 20, 2008 May 20, 2008 05/20/08
ScriptingGuy1
Hey, Scripting Guy! I read your article on renaming image files so that the pictures could then be sorted in chronological order. When I ran your script, however, it didn’t quite work for me: the files were renamed, but the pictures weren’t sorted the way I had hoped they would be. I think that’s because the pictures were being renamed...