Scripting Blog

A place to learn about PowerShell and share stories of automation

Microsoft Excel - Scripting Blog

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

September 11, 2009 Sep 11, 2009 09/11/09
ScriptingGuy1
Share this post: Hey Scripting Guy! I stumbled across the TechNet Script Center recently while trying to solve a problem I had at work. I had heard about scripting, of course, but had never taken the time to learn about it. I was able to find a script that resolved my issue at work, but now I am thinking I would like to learn...

Hey, Scripting Guy! Can I Sort a Tab-Separated Value File with Windows PowerShell 2.0?

August 20, 2009 Aug 20, 2009 08/20/09
ScriptingGuy1
  Hey Scripting Guy! I have a bunch of data in a tab-separated value (TSV) file that I need to sort based upon one of the columns. If you could help me it would be great. We are using Windows PowerShell 2.0 if that is of any importance to your solution. -- MLHello ML, Microsoft Scripting Guy Ed Wilson here. When your friends and family...

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

May 9, 2009 May 9, 2009 05/9/09
ScriptingGuy1
How Can I List All Servers in a Domain That Have DHCP Installed?  Hey, Scripting Guy! How can I quickly produce a list of all servers in the domain that have the DHCP Service installed?- SC Hi SC,On Windows Server 2008 and ater, use the WIN32_ServerFeature WMI class. The GetDHCPServer.vbs script shows this process:GetDHCPServer.vbs ...

Hey, Scripting Guy! How Can I Import Data into Office Access from Office Excel?

February 19, 2009 Feb 19, 2009 02/19/09
ScriptingGuy1
Hey, Scripting Guy! I need to do hardware inventory on all our workstations and on all our servers. I know System Center Configuration Manager can do this and a whole lot more. We actually have it budgeted for deployment next year. However, that does not help me now. We had a summer intern that went around and typed a lot of information such...

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

January 24, 2009 Jan 24, 2009 01/24/09
ScriptingGuy1
How Can I Return File Names of Files Created in Less Than an Hour from the Current Time? Hey, Scripting Guy! I am attempting to write a script that looks at the creation dates of all files in a certain directory. If the files were created less than an hour from the current time, the script will return those file names. The script will ...