Hey, Scripting Guy!

Archive

By: The Scripting Guys

Hey, Scripting Guy!

The Microsoft Scripting Guys address commonly-asked questions about system administration scripting. Got a question about system administration scripting? Then send an e-mail to scripter@microsoft.com (in English, if possible). We can’t guarantee we’ll be able to answer every question that comes our way, but we’ll do our best. You can also view "Hey, Scripting Guy!" articles by category.

 

July 2009

Week of July 3rd, 2009

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 7/3/09)
How Can I Prompt Users for Information When a Script Is Run? (Thurs. - 7/2/09)
How Can I Use a Named Parameter When Running Scripts? (Wed. - 7/1/09)
How Can I Supply More Than One Value from the Command Line? (Tues. - 6/30/09)
How Can I Run a Script Without Involving Notepad? (Mon. - 6/29/09)

June 2009

Week of June 26th, 2009

2009 Scripting Games Event 10 *Solutions* (Beginner and Advanced; 1,500-meter race) (Fri. - 6/26/09)
2009 Scripting Games Event 9 *Solutions* (Beginner and Advanced; javelin throw) (Thurs. - 6/25/09)
2009 Scripting Games Event 8 *Solutions* (Beginner and Advanced; pole vault) (Wed. - 6/24/09)
2009 Scripting Games Event 7 *Solutions* (Beginner and Advanced; discus throw) (Tues. - 6/23/09)
2009 Scripting Games Event 6 *Solutions* (Beginner and Advanced; 110-meter hurdles) (Mon. - 6/22/09)

Week of June 19th, 2009

2009 Scripting Games Event 10 Details (Beginner and Advanced; 1,500-meter race) (Fri. - 6/19/09)
2009 Scripting Games Event 5 *Solutions* (Beginner and Advanced; 400-meter race) (Fri. - 6/19/09)

2009 Scripting Games Event 9 Details (Beginner and Advanced; javelin throw) (Thurs. - 6/18/09)
2009 Scripting Games Event 4 *Solutions* (Beginner and Advanced; high jump) (Thurs. - 6/18/09)

2009 Scripting Games Event 8 Details (Beginner and Advanced; pole vault) (Wed. - 6/17/09)
2009 Scripting Games Event 3 *Solutions* (Beginner and Advanced; shot put) (Wed. - 6/17/09)

2009 Scripting Games Event 7 Details (Beginner and Advanced; discus throw) (Tues. - 6/16/09)
2009 Scripting Games Event 2 *Solutions* (Beginner and Advanced; long jump) (Tues. - 6/16/09)

2009 Scripting Games Event 6 Details (Beginner and Advanced; 110-meter hurdles) (Mon. - 6/15/09)
2009 Scripting Games Event 1 *Solutions* (Beginner and Advanced; 100-meter dash) (Mon. - 6/15/09)

Week of June 12th, 2009

2009 Scripting Games Event 5 Details (Beginner and Advanced; 400-meter race) (Fri. - 6/12/09)
2009 Scripting Games Event 4 Details (Beginner and Advanced; high jump) (Thurs. - 6/11/09)
2009 Scripting Games Event 3 Details (Beginner and Advanced; shot put) (Wed. - 6/10/09)
2009 Scripting Games Event 2 Details (Beginner and Advanced; long jump) (Tues. - 6/9/09)
2009 Scripting Games Event 1 Details (Beginner and Advanced; 100-meter dash) (Mon. - 6/8/09)

Week of June 5th, 2009

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 6/5/09)
How Can I Collect System Restore Information in Windows Vista? (Thurs. - 6/4/09)
How Can I Enable and Disable Offline Files? (Wed. - 6/3/09)
How Can I Work with the Offline Files Feature in Windows? (Tues. - 6/2/09)
How Can I Back Up Specific Folders on My Windows Computer? (Mon. - 6/1/09)

May 2009

Week of May 29th, 2009

How Can I Use Windows PowerShell to Run Daily Checks on My SQL Server 2008 Servers? (Fri. - 5/29/09)
How Can I Use the SQL Server Mini-Shell Version of Windows PowerShell? (Thurs. - 5/28/09)
How Does Windows PowerShell Make It Easier to Work with SQL Server 2008? (Wed. - 5/27/09)
Why Should I Use Windows PowerShell with SQL Server 2008? (Tues. - 5/26/09)
Happy Holiday (Mon. - 5/25/09)

Week of May 22nd, 2009

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 5/22/09)
How Can I Perform More Than One Action with the Win32_Printer WMI Class? (Thurs. - 5/21/09)
How Can I Use Use Windows PowerShell to Remove Old Printer Connections, List Printers, and Set New Default Printers? (Wed. - 5/20/09)
How Can I Use WMI to Add a Printer Connection by Using Windows PowerShell? (Tues. - 5/19/09)
How Can I Document Printer Usage on Client Workstations? (Mon. - 5/18/09)

Week of May 15th, 2009

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 5/15/09)
How Can I Use Windows PowerShell to Look for and Replace a Word in a Microsoft Word Document? (Thurs. - 5/14/09)
How Can I Convert to Windows PowerShell a VBScript Script That Creates a Table in Office Word? (Wed. - 5/13/09)
How Can I Convert to Windows PowerShell a VBScript Script to Which I Want to Make Significant Changes? (Tues. - 5/12/09)
How Can I Convert a VBScript to a Windows PowerShell Script That Creates an Office Word Document with Hyperlinks? (Mon. - 5/11/09)

Week of May 8th, 2009

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 5/8/09)
How Can I Evaluate a Condition and Select from Several Options with Windows PowerShell? (Thurs. - 5/7/09)
How Can I Use the If Statement in Windows PowerShell? (Wed. - 5/6/09)
How Can I Loop Through Collections with Windows PowerShell? (Tues. - 5/5/09)
How Can I Use Windows PowerShell to Handle Mind-Numbing, Repetitive Tasks? (Mon. - 5/4/09)

Week of May 1st, 2009

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 5/1/09)
More About Looping with Windows PowerShell (Thurs. - 4/30/09)
How Can I Use the Do...While...Loop in Windows PowerShell? (Wed. - 4/29/09)
How Can I Use the Windows PowerShell Equivalent of the VBScript While…Wend Loop? (Tues. - 4/28/09)
How Can I Write and Run a Windows PowerShell Script? (Mon. - 4/27/09)

April 2009

Week of April 24th, 2009

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 4/24/09)
How Can I Work with Directories, Files, and Folders by Using Windows PowerShell? (Thurs. - 4/23/09)
How Can I Identify and Delete an Instance of a Process? (Wed. - 4/22/09)
Windows PowerShell and Pipelining (Tues. - 4/21/09)
Windows PowerShell: An Introduction (Mon. - 4/20/09)

Week of April 17th, 2009

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 4/17/09)
How Can I Parse My Firewall Log File to See What Kind of Packets Are Being Sent? (Thurs. - 4/16/09)
How Can I See Which Packets Are Being Dropped by Windows Firewall? (Wed. - 4/15/09)
How Can I Convert a Tab-Delimited File to a Comma-Separated Value File? (Tues. - 4/14/09)
How Can I Create a Phone Directory from Text Files with Varying Formats? (Mon. - 4/13/09)

Week of April 10th, 2009

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 4/10/09)
How Can I Check My Event Logs to See Why My Computer Isn't Performing Well? (Thurs. - 4/9/09)
How Can I Check the Size of My Event Log and Then Backup and Archive It If It Is More Than Half Full? (Wed. - 4/8/09)
How Can I Query Event Logs to Discover Active Directory Information? (Tues. - 4/7/09)
How Can I Check My Event Logs? (Mon. - 4/6/09)

Week of April 3rd, 2009

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 4/3/09)
How Can I Run a Script When My Computer Is Idle? (Thurs. - 4/2/09)
How Do I Best Work with Task Scheduler? (Wed. - 4/1/09)
How Can I List and Delete Scheduled Jobs? (Tues. - 3/31/09)
How Can I Create a Scheduled Task on a Number of Computers? (Mon. - 3/30/09)

March 2009

Week of March 27th, 2009

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 3/27/09)
How Can I Identify All Local Users, Groups, and Services on a Local Computer? (Thurs. - 3/26/09)
How Can I Change the Passwords of Multiple Local Computer Accounts? (Wed. - 3/25/09)
How Can I Create More Than One User, Assign Attribute Values, and Assign the Users to Groups? (Tues. - 3/24/09)
How Can I Create the Same User Account and Password on Multiple Computers? (Mon. - 3/23/09)

Week of March 20th, 2009

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 3/20/09)
How Can I Search Active Directory and Produce a Report? (Thurs. - 3/19/09)
How Can I Search Active Directory with Windows PowerShell to Return a List of Missing Groups? (Wed. - 3/18/09)
How Can I Search Active Directory Using Windows PowerShell and the LDAP Search Filter? (Tues. - 3/17/09)
How Can I Search Active Directory? (Mon. - 3/16/09)

Week of March 13th, 2009

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 3/13/09)
How Can I Remove a Microsoft Update? (Thurs. - 3/12/09)
How Can I Search For, Download, and Install an Update? (Wed. - 3/11/09)
How Can I Tell Which Software Updates Are Available Via Windows Update? (Tues. - 3/10/09)
How Can I List All Updates That Have Been Added to a Computer? (Mon. - 3/9/09)

Week of March 6th, 2009

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 3/6/09)
How Can I Get WMI Information About More Than One Computer? (Thurs. - 3/5/09)
How Do I Migrate My VBScript WMI Queries to Windows PowerShell? (Wed. - 3/4/09)
How Do I Find the Names of WMI Classes? (Tues. - 3/3/09)
How Can I Use WMI with Windows PowerShell? (Mon. - 3/2/09)

February 2009

Week of February 27th, 2009

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 2/27/09)
How Do I Query and Retrieve DNS Information? (Thurs. - 2/26/09)
How Do I Create a New DNS Zone? (Wed. - 2/25/09)
How Can I Create DNS Mail Exchanger (MX) Records and Have a Text File Generated to Show What Was Created? (Tues. - 2/24/09)
How Do I Check Host Name Records? (Mon. - 2/23/09)

Week of February 20th, 2009

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 2/20/09)
How Can I Import Data into Office Access from Office Excel? (Thurs. - 2/19/09)
How Can I Tell Which Tables and Columns Are in a Database Without Opening It? (Wed. - 2/18/09)
How Can I Create a Database with More Than One Table? (Tues. - 2/17/09)
How Can I Use Windows PowerShell to Create an Office Access Database? (Mon. - 2/16/09)

Week of February 13th, 2009

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 2/13/09)
How Can I Generate a List of My Group Policy Objects? (Thurs. - 2/12/09)
How Can I Create New Group Policy Objects? (Wed. - 2/11/09)
How Can Get a List of All My Orphaned Group Policy Objects? (Tues. - 2/10/09)
How Can I List All Group Policy Objects in a Domain? (Mon. - 2/9/09)

Week of February 6th, 2009

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 2/6/09)
How Can I Hide My Desktop Wallpaper? (Thurs. - 2/5/09)
How Can I Rename All of the Pictures in a Folder? (Wed. - 2/4/09)
How Do I Rename All Files in a Folder? (Tues. - 2/3/09)
How Can I Tell How Much Free Disk Space a User Has? (Mon. - 2/2/09)

January 2009

Week of January 30th, 2009

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 1/30/09)
How Can I Display My Office Outlook Appointments Without Starting Office Outlook? (Thurs. - 1/29/09)
How Can I Notify Users of the Space Their Deleted Items Folder Is Using? (Wed. - 1/28/09)
How Do I Determine How Many Office Outlook E-Mail Messages I Sent in a Week? (Tues. - 1/27/09)
How Do I Use Windows PowerShell to Work with Junk E-Mail in Office Outlook? (Mon. - 1/26/09)

Week of January 23rd, 2009

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 1/23/09)
How Can I Stop an Unwanted Process? (Thurs. - 1/22/09)
How Can I Back Up a Database’s Data Folder While the Database Is Running? (Wed. - 1/21/09)
How Do I Display a Message and the Time a Process Was Terminated? (Tues. - 1/20/09)
How Can I Be Notified When a Process Begins? (Mon. - 1/19/09)

Week of January 16th, 2009

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 1/16/09)
How Can I Modify the Footers of an Office Excel Spreadsheet? (Thurs. - 1/15/09)
How Do I Center Contents of a Column in Office Excel? (Wed. - 1/14/09)
How Do I Run an Office Excel Macro on Multiple Workbooks? (Tues. - 1/13/09)
How Do I Add a Function to an Office Excel Spreadsheet? (Mon. - 1/12/09)

Week of January 9th, 2009

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 1/9/09)
How Can I Configure the Cmd Console via the Registry? (Thurs. - 1/8/09)
How Can I Change My Internet Explorer Home Page? (Wed. - 1/7/09)
How Can I Modify Registry Settings That Configure Windows Explorer? (Tues. - 1/6/09)
How Do I Tell Which Version of Windows PowerShell I'm Using? (Mon. - 1/5/09)

Week of January 2nd, 2009

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 1/2/09)
How Can I Copy a File Multiple Times and Give a Unique Name to Each File? (Thurs. - 1/1/09)
How Can I Create File Names Based on Their Time Stamp? (Wed. - 12/31/08)
How Do I Back Up Files That Have Been Modified in the Last Day? (Tues. - 12/30/08)
How Can I Delete and Manage PDF Files? (Mon. - 12/29/08)

December 2008

Week of December 26th, 2008

Scripting Guys on Holiday (Mon.–Fri., 12/22/08–12/26/08)

Week of December 19th, 2008

Greatest Hits Week! How Can I Search a Word Document for All the Words in Double Brackets? (Fri. - 12/19/08)
Greatest Hits Week! How Can I Boldface a Specific Word Throughout a Microsoft Word Document? (Thurs. - 12/18/08)
Greatest Hits Week! How Can I Write a Script That Accesses All the Subfolders in My Outlook Inbox? (Wed. - 12/17/08)
Greatest Hits Week! How Can I Password-Protect an Excel Spreadsheet? (Tues. - 12/16/08)
Greatest Hits Week! Can I Create and Delete a Data Sources Name Using a Script? (Mon. - 12/15/08)

Week of December 12th, 2008

Greatest Hits Week! How Can I Determine the Follow-Up Status of Outlook E-Mail Messages? (Fri. - 12/12/08)
Greatest Hits Week! How Can I Take Ownership of a File or Folder By Using a Script? (Thurs. - 12/11/08)
Greatest Hits Week! How Can I Delete All Files Older Than a Specified Date? (Wed. - 12/10/08)
Greatest Hits Week! How Can I Change the Target of a Desktop Shortcut? (Tues. - 12/9/08)
Greatest Hits Week! How Can I Tell Whether the NumLock Key is On or Off? (Mon. - 12/8/08)

Week of December 5th, 2008

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 12/5/08)
How Can I Document Printers? (Thurs. - 12/4/08)
How Can I Kill Processes? (Wed. - 12/3/08)
How Can I Easily Reconfigure Services? (Tues. - 12/2/08)
How Can I Have Computer Configuration Information Written to an HTML File? (Mon. - 12/1/08)

November 2008

Week of November 28th, 2008

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 11/28/08)
How Can I Pull Server Diagnostic Information and Have It Saved in an Excel Spreadsheet with a Chart? (Thurs. - 11/27/08)
How Can I Collect Processor Information? (Wed. - 11/26/08)
How Can I Determine the Average Process Utilization for My Computer? (Tues. - 11/25/08)
How Can I Control the Data Returned by the Performance Monitor Tool? (Mon. - 11/24/08)

Week of November 21st, 2008

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 11/21/08)
How Can I Find Locked-Out Accounts? (Thurs. - 11/20/08)
How Can I Find Old Computer Accounts? (Wed. - 11/19/08)
How Can I Find Expiring Passwords? (Tues. - 11/18/08)
How Can I Locate Missing Attributes in Active Directory Domain Services? (Mon. - 11/17/08)

Week of November 14th, 2008

Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (Fri. - 11/14/08)
How Can I Count How Many Images Are Embedded in Microsoft Word Documents? (Thurs. - 11/13/08)
How Can I Convert Word Files to PDF Files? (Wed. - 11/12/08)
How Can I Create a Microsoft Word Document from WMI Information? (Tues. - 11/11/08)
How Can I Check Spelling and Grammar in Microsoft Word? (Mon. - 11/10/08)

Week of November 7th, 2008

How Can I Format a Microsoft Word Paragraph? (Thurs. - 11/6/08)
How Can I Add a Windows PowerShell Shortcut to the Quick Launch Toolbar? (Mon. - 11/3/08)

October 2008

Week of October 31st, 2008

How Can I Determine Folder Size? (Thurs. - 10/30/08)
How Can I Create an HTA to Do Temperature Conversions? (Mon. - 10/27/08)

Week of October 24th, 2008

How Can I Edit Terminal Server Profiles for Users in Active Directory? (Thurs. - 10/23/08)
How Can I Create Users from a CSV File? (Mon. - 10/20/08)

Week of October 17th, 2008

How Can I Create Passwords for My Users? (Thurs. - 10/16/08)
How Can I Read a CSV File? (Mon. - 10/13/08)

Week of October 10th, 2008

How Can I Read Microsoft Excel Metadata? (Thurs. - 10/9/08)
Australian Dispatch #3: Self-Contained Under Water Breathing Apparatus (Mon. - 10/6/08)

Week of October 3rd, 2008

How Can I Reuse Functions? (Thurs. - 10/2/08)
How Can I Enable or Disable My Network Adapter? (Mon. - 9/29/08)

September 2008

Week of September 26th, 2008

Australian Dispatch #2: A Metric Ton of Scripting (Thurs. - 9/25/08)
Australian Dispatch #1: How Does a Scripting Guy Pack for a Trip (Mon. - 9/22/08)

Week of September 19th, 2008

How Do I Write to Excel Without Using Excel? (Mon. - 9/15/08)

Week of September 12th, 2008

How Do I Read from Excel Without Using Excel? (Thurs. - 9/11/08)
How Do I Find Information About the Network Adapter Cards on My Computer? (Mon. - 9/8/08)

Week of September 5th, 2008

How Can I Tell When I Was Last Logged On? (Thurs. - 9/4/08)
How Do I Use Windows PowerShell to Run the Same WMI Queries Against Multiple Computers? (Tues. - 9/2/08)

August 2008

Week of August 29th, 2008

What's Going on in the Service Host Process? (Thurs. - 8/28/08)
How Can I Troubleshoot Drive-Mapping Issues? (Mon. - 8/25/08)

Week of August 22nd, 2008

How Do I Track Server Downtime? (Thurs. - 8/21/08)
How Long Has My Server Been Up? (Mon. - 8/18/08)

Week of August 15th, 2008

How Can I Find Files' Metadata? (Wed. - 8/13/08)
When Will We Land? (Mon. - 8/11/08)

Week of August 1st, 2008

How Can I Compare Files With the Same Name But Two Different Extensions? (Mon. - 7/28/08)

July 2008

Week of July 25th, 2008

How Can I Load a Drop-Down List From a Text File? (Mon. - 7/21/08)

Week of July 18th, 2008

How Can I Read the MAC Address From a Text File?  (Tues. – 7/15/08)

Week of July 4th, 2008

Happy Holiday (Fri. – 7/4/08)
Happy Pre-Holiday (Thurs. – 7/3/08)
How Can I Replace a Series of Variables Found in a Text File with Values Taken From That File?  (Wed. – 7/2/08)
How Can I Summarize Information Found in a Spreadsheet Row?  (Tues. – 7/1/08)
How Can I Copy Specified Sections of an .RTF File to a New Word Document?  (Mon. – 6/30/08)

June 2008

Week of June 27th, 2008

How Can I Prevent Excel From Turning My Imported Numbers Into Dates?  (Fri. – 6/27/08)
How Can I Copy Files Based on Multiple Criteria?  (Thurs. – 6/26/08)
How Can I Add a Hyperlink to a Microsoft Outlook Signature?  (Wed. – 6/25/08)
How Can I Change a Registry Value Named (Default)?  (Tues. – 6/24/08)
How Can I Open and Close Outlook Attachments?  (Mon. – 6/23/08)

Week of June 20th, 2008

How Can I Change the Letter Case of My File Names?  (Fri. – 6/20/08)
How Can I Modify a Text File Based on the Value of a Particular Column in the File?  (Thurs. – 6/19/08)
How Can I Use a File Mask When Renaming Files?  (Wed. – 6/18/08)
How Can I Remove the Speaker Notes From a PowerPoint Presentation?  (Tues. – 6/17/08)
How Can I Remove Specified Commas from a Comma-Separated Values File?  (Mon. – 6/16/08)

Week of June 13th, 2008

How Can I Retrieve Free/Busy Time From Microsoft Outlook?  (Fri. – 6/13/08)
How Can I Run a Command-Line Tool Multiple Times and Save the Output to a Text File?  (Thurs. – 6/12/08)
How Can I Get a List of All the Styles in a Word Document?  (Wed. – 6/11/08)
How Can I Get a Script to Pick Up Where It Left Off After a Reboot?  (Tues. – 6/10/08)
How Can I Apply a Timeout to an InputBox?  (Mon. – 6/9/08)

Week of June 6th, 2008

How Can I Add a Line to the Beginning of a Text File And Simultaneously Delete the Last Line of That File?  (Fri. – 6/6/08)
How Can I Save My Outlook Contacts as .MSG Files?  (Thurs. – 6/5/08)
How Can I Determine the Largest Value in a Table Column in Microsoft Word?  (Wed. – 6/4/08)
How Can I Move Files Based on Their Three-Part File Name?  (Tues. – 6/3/08)
How Can I Use Leading Zeroes When Displaying a Value in Windows PowerShell?  (Mon. – 6/2/08)

May 2008

Week of May 30th, 2008

How Can I Copy the Extended Data of My Audio Files to an Excel Spreadsheet?  (Fri. – 5/30/08)
How Can I Search For a Specific Style in a Folder Full of Microsoft Word Documents?  (Thurs. – 5/29/08)
How Can I Report Back File Dates Using Labels Like Today, Yesterday, and Last Week?  (Wed. – 5/28/08)
How Can I Tile Workbook Windows in Microsoft Excel?  (Tues. – 5/27/08)
Happy Holiday  (Mon. – 5/26/08)

Week of May 23rd, 2008

How Can I Extract Miscellaneous Computer Names From a Text File?  (Fri. – 5/23/08)
How Can I Use Windows PowerShell to Determine Whether a Local User Account Exists?  (Thurs. – 5/22/08)
How Can I Remove Delimiters, and Fix Apostrophes, in a CSV File?  (Wed. – 5/21/08)
How Can I Compare Two Strings Values and Then Report Back the Result of That Comparison?  (Tues. – 5/20/08)
How Can I Sort Digital Files By the Date Each Picture Was Taken?  (Mon. – 5/19/08)

Week of May 16th, 2008

How Can I Search a Folder For All the Image Files That Are Not a Specified Height and Width?  (Fri. – 5/16/08)
How Can I Delete All the Files in a Folder Except for the Most-Recently Created File?  (Thurs. – 5/15/08)
How Can I Search a Text File for Activities That Took Place on a Specified Date?  (Wed. – 5/14/08)
How Can I Move Emails From One Outlook Folder to Another?  (Tues. – 5/13/08)
How Can I Determine the Distinguished Name of the OU Where the Logged-On User’s User Account Resides?  (Mon. – 5/12/08)

Week of May 9th, 2008

How Can I Use Windows PowerShell to Pick Out the Unique File Extensions Used in a Collection of Files?  (Fri. – 5/9/08)
How Can I Use Windows PowerShell to Report Back the Name and Creation Date for Files Containing a Specified String Value?  (Thurs. – 5/8/08)
How Can I Copy a Portion of a Microsoft Word Document to a New Microsoft Word Document?  (Wed. – 5/7/08)
How Can I Modify a .CSV File and Then Import That File into Microsoft Excel?  (Tues. – 5/6/08)
How Can I Search for a Word in a Text File and Return the Entire Line Where That Word Was Found?  (Mon. – 5/5/08)

Week of May 2nd, 2008

How Can I Identify the 20 Most-Recently Modified Files in a Folder?  (Fri. – 5/2/08)
How Can I Change the Value and Color of a Spreadsheet Cell Based on the Sum of Other Cells in That Spreadsheet?  (Thurs. – 5/1/08)
How Can I Sort a Text File Based on a Specific Column in That File?  (Wed. – 4/30/08)
How Can I Read a Text File and Extract All the Text Enclosed in Double Quote Marks?  (Tues. – 4/29/08)
How Can I Use Windows PowerShell to Determine the Number of Lines in a Text File?  (Mon. – 4/28/08)

April 2008

Week of April 25th, 2008

How Can I Install Fonts Using a Script?  (Fri. – 4/25/08)
How Can I Pass Command-Line Arguments to a Batch File Started From a Script?  (Thurs. – 4/24/08)
How Can I Randomly Assign a Font to Characters in a Word Document?  (Wed. – 4/23/08)
How Can I Schedule a Meeting Each Monday Through Friday For Two Weeks?  (Tues. – 4/22/08)
How Can I Monitor a Folder for the Creation of New Subfolders?  (Mon. – 4/21/08)

Week of April 18th, 2008

How Can I Parse a Text File and Retrieve All the Information Contained Within Square Brackets?  (Fri. – 4/18/08)
How Can I Store Arrays Within Another Array?  (Thurs. – 4/17/08)
How Can I Find Folders Whose Name Fits a Specified Pattern?  (Wed. – 4/16/08)
How Can I Use Windows PowerShell to Determine the Owner of a File?  (Tues. – 4/15/08)
How Can I Import a Fixed-Width Data File into Microsoft Excel?  (Mon. – 4/14/08)

Week of April 11th, 2008

How Can I Use Windows PowerShell to Look at All the Microsoft Office Documents in a Folder?  (Fri. – 4/11/08)
How Can I Delete Duplicate Entries in a Tab-Delimited File?  (Thurs. – 4/10/08)
How Can I Conditionally Add Lines to a Text File?  (Wed. – 4/9/08)
How Can I Retrieve All the Values in a Registry Key?  (Tues. – 4/8/08)
How Can I Check to See if Two Lines of Text are in a File and, If They Aren’t, Append Those Lines to the File?  (Mon. – 4/7/08)

Week of April 4th, 2008

How Can I Determine the Currency Symbol in Use on a Computer?  (Fri. – 4/4/08)
How Can I Separate The Month From the Year in a Date String Like 122007?  (Thurs. – 4/3/08)
How Can I Sort Items Retrieved From a Microsoft Outlook Folder?  (Wed. – 4/2/08)
How Can I Open an Alternate Home Page If the Default Home Page Isn’t Available?  (Tues. – 4/1/08)
How Can Retrieve a List of All My Computer Accounts, Grouped By OU?  (Mon. – 3/31/08)

March 2008

Week of March 28th, 2008

How Can I Retrieve Information About All the Shortcut Files in a Folder?  (Fri. – 3/28/08)
How Can I Incrementally Rename Files Based on the File Creation Date?  (Thurs. – 3/27/08)
How Can I Change the Last-Accessed Date of a File to Match Its Last-Modified Date?  (Wed. – 3/26/08)
How Can I Standardize the Logon Name for All My Users?  (Tues. – 3/25/08)
How Can I Add a Hotkey to an HTA Button?  (Mon. – 3/24/08)

Week of March 21st, 2008

How Can I Use Data Read From a Text File as Command-Line Parameters For a Batch File?  (Fri. – 3/21/08)
How Can I Use Both AND and OR Operators in a Single WMI Query?  (Thurs. – 3/20/08)
How Can I List the Members of a Domain Group That Belongs to the Local Administrators Group?  (Wed. – 3/19/08)
How Can I Retrieve the User Name and User Initials From Microsoft PowerPoint?  (Tues. – 3/18/08)
How Can I Get a List of Active Directory Groups That Have Just 1 Member or Fewer?  (Mon. – 3/17/08)

Week of March 14th, 2008

How Can I Copy a File to a Removable Drive If I Don’t Know the Drive Letter of That Drive?  (Fri. – 3/14/08)
How Can I Find the Number (and Size) of All the Files Recently Modified or Added to a Computer?  (Thurs. – 3/13/08)
How Can I Sort a Spreadsheet By Cell Color?  (Wed. – 3/12/08)
How Can I Use Windows PowerShell to Add a Domain User to a Local Group?  (Tues. – 3/11/08)
How Can I Return a List of All the Folders Whose Name Starts With a Specified String Value?  (Mon. – 3/10/08)

Week of March 7th, 2008

How Can I Get an HTA to Remember Its Previous Position Onscreen?  (Fri. – 3/7/08)
How Can I Write a Message to All the Empty Files in a Folder?  (Thurs. – 3/6/08)
How Can I Verify That a User Entered a Valid Drive Letter?  (Wed. – 3/5/08)
How Can I Map a Drive Based on the Computer’s Subnet?  (Tues. – 3/4/08)
How Can I Change a File That’s Found in a Folder and in All Its Top-Level Subfolders?  (Mon. – 3/3/08)

February 2008

Week of February 29th, 2008

How Can I List All the Users in an OU Who Are Not Members of a Specified Group?  (Fri. – 2/29/08)
How Can I Move Files Based on a Portion of the File Name?  (Thurs. – 2/28/08)
How Can I Create a GUID Using Windows PowerShell?  (Wed. – 2/27/08)
How Can I Check the Value of a Specific Cell in a Bunch of Excel Spreadsheets?  (Tues. – 2/26/08)
How Can I Find a Word in a Document and Change the Background Color of the Paragraph Where That Word Appears?  (Mon. – 2/25/08)

Week of February 22nd, 2008

How Can I Replace Incorrect Dates in My File Names?  (Fri. – 2/22/08)
How Can I Set a Reminder on All My Outlook Appointments?  (Thurs. – 2/21/08)
How Can I Mark the First Occurrence of a Number in an Excel Spreadsheet?  (Wed. – 2/20/08)
How Can I Enable Users to Change File Extensions Using the SendTo Command?  (Tues. – 2/19/08)
How Can I Extract Three-Digit Numbers From a String?  (Mon. – 2/18/08)

Week of February 15th, 2008

How Can I Use a Disconnected Recordset in Windows PowerShell?  (Fri. – 2/15/08)
How Can I Run a Subroutine in an HTA After a Set Amount of Time?  (Thurs. – 2/14/08)
How Can I Convert Pacific Standard Time to My Local Time?  (Wed. – 2/13/08)
How Can I Use Windows PowerShell to Sort a CSV File?  (Tues. – 2/12/08)
How Can I Remove Extraneous Spaces From Fields in a Text File?  (Mon. – 2/11/08)

Week of February 8th, 2008

How Can I Select Text in a HTA and Then Append That Text to a File?  (Fri. – 2/8/08)
How Can I Read Custom Summary Information Properties for an Excel File?  (Thurs. – 2/7/08)
How Can I Read Computer Names From a Text File and Then Verify Whether or Not Those Computers Still Exist?  (Wed. – 2/6/08)
How Can I Count the Number of Sentences and Paragraphs in a Word Document?  (Tues. – 2/5/08)
How Can I Create an HTA For Displaying Log Files?  (Mon. – 2/4/08)

Week of February 1st, 2008

How Can I Randomly Assign a Sound to a Sound Event?  (Fri. – 2/1/08)
How Can I Use Windows PowerShell to Retrieve the Non-Unique Items in a List?  (Thurs. – 1/31/08)
How Can I Display a Message or Change the Cursor When Carrying Out a Lengthy Operation in an HTA?  (Wed. – 1/30/08)
How Can I Change the Color of a Spreadsheet Cell Based on a Range of Values?  (Tues. – 1/29/08)
How Can I Create a Disk Quota That Gives the User Unlimited Disk Space?  (Mon. – 1/28/08)

January 2008

Week of January 25th, 2008

How Can I Schedule an All-Day Event in Microsoft Outlook?  (Fri. – 1/25/08)
How Can I Sort the Contents of a Text File in Numerical Order?  (Thurs. – 1/24/08)
How Can I Change the Priority of Each Instance of an Application?  (Wed. – 1/23/08)
How Can I Synchronize a Text File of Folder Names With the Subfolders in a Folder?  (Tues. – 1/22/08)
How Can I Import Multiple Worksheets into an Access Database?  (Mon. – 1/21/08)

Week of January 18th, 2008

How Can I Search For Values in an Excel Worksheet?  (Fri. – 1/18/08)
How Can I Use Windows PowerShell to Replace Characters in a Text File?  (Thurs. – 1/17/08)
How Can I Extract Specific Information From a Word Document and Then Use That Information to Rename the Document?  (Wed. – 1/16/08)
How Can I Add a Record to a Database Using Windows PowerShell?  (Tues. – 1/15/08)
How Can I Search For a Folder and Return the Folder Path?  (Mon. – 1/14/08)

Week of January 11th, 2008

How Can I Tally All the Items in a Microsoft Word Document?  (Fri. – 1/11/08)
How Can I List All the Duplicate Files in a Folder and Its Subfolders?  (Thurs. – 1/10/08)
How Can I Reset the Revision Number of a Word Document to 1?  (Wed. – 1/9/08)
How Can I Modify the Email Addresses of All the Users in an OU and Its SubOUs?  (Tues. – 1/8/08)
How Can I Copy the Membership of a Local Group to a New Local Group?  (Mon. – 1/7/08)

Week of January 4th, 2008

How Can I Add a Domain Group to a Local Group?  (Fri. – 1/4/08)
How Can I Delete a Set of Records From an Access Database?  (Thurs. – 1/3/08)
How Can I Remove Group Members Whose User Accounts Reside in a Specific OU?  (Wed. – 1/2/08)
Happy Holiday (Tues. 1/1/08)
Happy Holiday (Mon. 12/31/07)

December 2007

Week of December 28th, 2007

Happy Holiday (Monday 12/24/07 – Friday 12/28/07)

Week of December 21st, 2007

Happy Holiday (Monday 12/17/07 – Friday 12/21/07)

Week of December 14th, 2007

How Can I Determine If Any of the Files in a Folder Have Been Modified in the Past 90 Days?  (Fri. – 12/14/07)
How Can I Remove Duplicate Values From a Pair of Text Files?  (Thurs. – 12/13/07)
How Can I Change the Background Color of a Text Box?  (Wed. – 12/12/07)
How Can I Delete Files That Are a Specified Number of Hours Old?  (Tues. – 12/11/07)
How Can I Replace Text That Includes Double Quote Marks and a Tab Character?  (Mon. – 12/10/07)

Week of December 7th, 2007

How Can I Map Drives Based on Membership in an Active Directory Group When the User Belongs to Multiple Groups?  (Fri. – 12/7/07)
How Can I Map Drives Based on Membership in an Active Directory Group?  (Thurs. – 12/6/07)
How Can I Start a Script in a Hidden Window?  (Wed. – 12/5/07)
How Can I Cut a Row From One Excel Spreadsheet and Paste That Row Into Another Spreadsheet?  (Tues. – 12/4/07)
How Can I Start an Application From a Windows PowerShell Script, Then Pause the Script Until the Application Has Terminated?  (Mon. – 12/3/07)

November 2007

Week of November 30th, 2007

How Can I Change the Font Size of a Span in an HTA?  (Fri. – 11/30/07)
How Can I Remove Everything From an Active Directory Group Except Other Groups?  (Thurs. – 11/29/07)
How Can I Determine the Manager for All the Groups in Active Directory?  (Wed. – 11/28/07)
How Can I Retrieve Time Zone Information for a Computer?  (Tues. – 11/27/07)
How Can I Randomly Assign a Picture From the My Pictures Folder as the Computer Wallpaper?  (Mon. – 11/26/07)

Week of November 23rd, 2007

Happy Holiday (Fri. 11/23/07)
Happy Holiday (Thurs. 11/22/07)
How Can I Tell If a Time Occurred in the Morning or the Evening?  (Wed. – 11/21/07)
How Can I Limit the Number of Characters That Can Be Typed Into a Textarea?  (Tues. – 11/20/07)
How Can I Tell If a Computer Has a SmartCard Reader Attached?  (Mon. – 11/19/07)

Week of November 16th, 2007

How Can I Set the Date and Time on a Computer?  (Fri. – 11/16/07)
How Can I Create a Self-Updating Text Box in an HTA?  (Thurs. – 11/15/07)
How Can I Run a Script Any Time Outlook is Started?  (Wed. – 11/14/07)
How Can I Remove Old Files From All the Folders That Share a Folder Name?  (Tues. – 11/13/07)
How Can I Extract a User Name and Drive Name From a String Value?  (Mon. – 11/12/07)

Week of November 9th, 2007

How Can I Save Information in an HTA as a Tab-Separated Values File?  (Fri. – 11/9/07)
How Can I Get the Name and whenCreated Values for All the Users in Active Directory?  (Thurs. – 11/8/07)
How Can I Remove a Value From the Path Environment Variable?  (Wed. – 11/7/07)
How Can I Create a Bunch of .WAV Files in a Folder?  (Tues. – 11/6/07)
How Can I Make the Name of the File the First Line of Each Text File in a Folder?  (Mon. – 11/5/07)

Week of November 2nd, 2007

How Can I Remove All the Network Printers on a Computer?  (Fri. – 11/2/07)
How Can I Determine the Value of the Last Cell in an Excel Range?  (Thurs. – 11/1/07)
How Can I Use Windows PowerShell to Delete All the Files in a Folder Older Than 90 Days?  (Wed. – 10/31/07)
How Can I Determine the Age, in Years, of an Outlook Contact?  (Tues. – 10/30/07)
How Can I Start a Remote Process Under CScript If the Script Path Contains Blank Spaces?  (Mon. – 10/29/07)

October 2007

Week of October 26th, 2007

How Can I Present a Dialog Box that Allows Users to Rename Files?  (Fri. – 10/26/07)
How Can I Be Notified if an Access Database File Exceeds a Specific Size?  (Thurs. – 10/25/07)
How Can I Move Files Based on a Value in the File Name?  (Wed. – 10/24/07)
How Can I Extract All the Text Between Two Tags in a Text File?  (Tues. – 10/23/07)
How Can I Convert an Excel Serial Number to a Date and Then Back?  (Mon. – 10/22/07)

Week of October 19th, 2007

How Can I Retrieve a List of Unique Users from the Security Event Log?  (Fri. – 10/19/07)
How Can I Tell if a Computer is Bluetooth-Enabled?  (Thurs. – 10/18/07)
How Can I Insert New Rows Above the Last Row in an Excel Spreadsheet?  (Wed. – 10/17/07)
How Can I Copy Data from Excel to PowerPoint?  (Tues. – 10/16/07)
How Can I Determine the Percentage of Free Space on a Drive?  (Mon. – 10/15/07)

Week of October 12th, 2007

How Can I Map Drives Based on IP Address?  (Fri. – 10/12/07)
How Can I Retrieve Hyperlink Information From an Excel Spreadsheet?  (Thurs. – 10/11/07)
How Can I Search Multiple OUs in Active Directory?  (Wed. – 10/10/07)
How Can I Insert Blank Rows (and Formulas) Into an Excel Worksheet?  (Tues. – 10/9/07)
How Can I Remove Unwanted Tabs From a Text File?  (Mon. – 10/8/07)

Week of October 5th, 2007

How Can I Save the Attachments for All My New Outlook Messages?  (Fri. – 10/5/07)
How Can I Convert an Extension Number to an Actual Phone Number?  (Thurs. – 10/4/07)
How Can I Retrieve the Field Size and a Sample Record For All the Tables and Fields in an Access Database?  (Wed. – 10/3/07)
How Can I Automatically Move the Focus as Users Type in an HTA?  (Tues. – 10/2/07)
How Can I Search a Text File for Terms Read In From a Second Text File?  (Mon. – 10/1/07)

September 2007

Week of September 28th, 2007

How Can I Retrieve Field Values in a Microsoft Word Document?  (Fri. – 9/28/07)
How Can I Retrieve IP Addresses (and Only IP Addresses) From a Text File?  (Thurs. – 9/27/07)
How Can I Create a New Folder in Microsoft Outlook?  (Wed. – 9/26/07)
How Can I Allow Users to Type Text Into an HTA Table?  (Tues. – 9/25/07)
How Can I Change the Paragraph Case in Microsoft Word?  (Mon. – 9/24/07)

Week of September 21st, 2007

How Can I Apply a New Template to a PowerPoint Presentation?  (Fri. – 9/21/07)
How Can I Dynamically Show Available Drive Letters in a List Box?  (Thurs. – 9/20/07)
How Can I Count the Number of Users in a Group?  (Wed. – 9/19/07)
How Can I Move Files Off a User’s Desktop and Into Specified Folders?  (Tues. – 9/18/07)
How Can I Parse a Comma-Separated Values File?  (Mon. – 9/17/07)

Week of September 14th, 2007

How Can I Extract Text Embedded Between Target Phrases in a Text File?  (Fri. – 9/14/07)
How Can I Determine Which Version of Windows Vista is Installed on a Computer?  (Thurs. – 9/13/07)
How Can I Update and Then Break All the Links in an Excel Spreadsheet?  (Wed. – 9/12/07)
How Can I Open All the Excel Spreadsheets in a Folder and Run a Specified Macro Found in Each of Those Spreadsheets?  (Tues. – 9/11/07)
How Can I Assign Multiple Home Pages to Internet Explorer 7.0?  (Mon. – 9/10/07)

Week of September 7th, 2007

How Can I Remove Any Line in a Text File That Contains a Specified String Value?  (Fri. – 9/7/07)
How Can I Backup an Event Log to a Text File?  (Thurs. – 9/6/07)
How Can I List the Addresses in My Sent Items Folder in an Excel Spreadsheet?  (Wed. – 9/5/07)
How Can I Add a Background Picture to an Excel Worksheet?  (Tues. – 9/4/07)
Happy Holiday (Mon. 9/3/07)

August 2007

Week of August 31st, 2007

How Can I Remove All the Non-Alphabetic Characters in a String?  (Fri. – 8/31/07)
How Can I Execute a Scheduled Task in Windows Vista?  (Thurs. – 8/30/07)
How Can I Reverse All the Lines in a Text File?  (Wed. – 8/29/07)
How Can I Get a List of Appointments for a Specific Month?  (Tues. – 8/28/07)
How Can I Find All the Files in a Directory Tree that Contain a Specific Word or Phrase?  (Mon. – 8/27/07)

Week of August 24th, 2007

How Can I Replace Numeric Values in an Excel Spreadsheet?  (Fri. – 8/24/07)
How Can I Delete the Oldest File From a Folder If and When That Folder Exceeds a Specified Size?  (Thurs. – 8/23/07)
How Can I Get the GUID for a User Account If All I Have is the User’s Logon Name and Domain?  (Wed. – 8/22/07)
How Can I Copy Data From One Spreadsheet to Another?  (Tues. – 8/21/07)
How Can I Tell If a Wireless Network Adapter is Connected to the Network?  (Mon. – 8/20/07)

Week of August 17th, 2007

How Can I Report Disk Quota Information For the Logged-on User?  (Fri. – 8/17/07)
How Can I Copy the Folder Structure of a Folder?  (Thurs. – 8/16/07)
How Can I Replace Text in an Excel Spreadsheet?  (Wed. – 8/15/07)
How Can I Combine Lines in a Text File?  (Tues. – 8/14/07)
How Can I Insert a Manual Line Break into a Microsoft Word Document?  (Mon. – 8/13/07)

Week of August 10th, 2007

How Can I Determine If the Number of Files in a Series of Folders Exceeds a Specified Value?  (Fri. – 8/10/07)
How Can I Save Emails That Are More Than One Month Old?  (Thurs. – 8/9/07)
How Can I Copy Two Files to Each of the Shared Folders on a Computer?  (Wed. – 8/8/07)
How Can I Search For and Modify Formatted Text in a Word Document?  (Tues. – 8/7/07)
How Can I Create a Sequential Series of Folders?  (Mon. – 8/6/07)

Week of August 3rd, 2007

How Can I Add the Date a Picture Was Taken to the File Names of My Digital Photos?  (Fri. – 8/3/07)
How Can I Get a List of User Accounts Created On Or Between Two Dates?  (Thurs. – 8/2/07)
How Can I Play a Sound Each Time a Message Box is Displayed?  (Wed. – 8/1/07)
How Can I Create a New Outlook Distribution List Based On the Membership of an Active Directory Group?  (Tues. – 7/31/07)
How Can I Dynamically Link Two Drop-Down Lists?  (Mon. – 7/30/07)

July 2007

Week of July 27th, 2007

How Can I Map a Printer Based on the Computer’s OU?  (Fri. – 7/27/07)
How Can I Configure PowerPoint to Print Handouts Instead of Slides?  (Thurs. – 7/26/07)
How Can I Create a New WMI Namespace Under the Root Namespace?  (Wed. – 7/25/07)
How Can I Save All My Contacts as VCards?  (Tues. – 7/24/07)
How Can I Check Every 30 Minutes to See If a File Has Been Modified?  (Mon. – 7/23/07)

Week of July 20th, 2007

How Can I Delete Specified Characters From the Beginning and End of My File Names?  (Fri. – 7/20/07)
How Can I Create a Custom Dialog Box?  (Thurs. – 7/19/07)
How Can I Add an HTML Tag to the End of Each Line in a File?  (Wed. – 7/18/07)
How Can I Display a Default Message If Nothing Has Been Typed Into a Text Box?  (Tues. – 7/17/07)
How Can I List the Network Printers For the Logged-On User?  (Mon. – 7/16/07)

Week of July 13th, 2007

How Can I Create a File of a Specified Size?  (Fri. – 7/13/07)
How Can I Use Windows PowerShell to Retrieve Environment Variables and Special Folder Paths?  (Thurs. – 7/12/07)
How Can I Ensure That a User Enters Only Allowed Characters in a Text Box?  (Wed. – 7/11/07)
How Can I Insert a Page Break in a Text File After Each Line Where the Only Character is the Number 1?  (Tues. – 7/10/07)
How Can I List All the Fields and Data Types in an Access Database?  (Mon. – 7/9/07)

Week of July 6th, 2007

How Can I Set the Print Area in an Excel Spreadsheet?  (Fri. – 7/6/07)
How Can I Replace Null Values in an Array?  (Thurs. – 7/5/07)
Happy Holiday (Wed. 7/4/07)
How Can I Change the Local Administrator Password on All My Computers?  (Tues. – 7/3/07)
How Can I Create a Folder With a Name Based on the Monday and Friday of the Coming Week?  (Mon. – 7/2/07)

June 2007

Week of June 29th, 2007

How Can I Delete Unread Emails That Are More Than 6 Months Old?  (Fri. – 6/29/07)
How Can I Prompt for a Computer Name and Then Delete That Computer Account From Active Directory?  (Thurs. – 6/28/07)
How Can I Remap Network Drives So They Use an IP Address Rather Than a Computer Name?  (Wed. – 6/27/07)
How Can I Search For Red Text in a Microsoft Word Document?  (Tues. – 6/26/07)
How Can I Create a Folder for Each User in My Domain?  (Mon. – 6/25/07)

Week of June 22nd, 2007

How Can I Delete Specified Rows in an Excel Spreadsheet?  (Fri. – 6/22/07)
How Can I Open a Window to a UNC Location?  (Thurs. – 6/21/07)
How Can I Color Every Other Row in an Excel Spreadsheet?  (Wed. – 6/20/07)
How Can I Insert Commas at Specified Locations in Each Line in a Text File?  (Tues. – 6/19/07)
How Can I Remove a Specific Set of Users From the Local Administrators Group?  (Mon. – 6/18/07)

Week of June 15th, 2007

How Can I Randomly Select an Email From an Outlook Mail Folder?  (Fri. – 6/15/07)
How Can I Change the Default File Save Format in Microsoft Word?  (Thurs. – 6/14/07)
How Can I Rename a File Every Day, Using the Current Date as Part of the File Name?  (Wed. – 6/13/07)
How Can I Put the File Name in the Footer of a Microsoft Word Document?  (Tues. – 6/12/07)
How Can I Clear the Contents of a Text File?  (Mon. – 6/11/07)

Week of June 8th, 2007

How Can I Get a List of All the PDF Files in a Folder and Its Subfolders?  (Fri. – 6/8/07)
How Can I Create a Shortcut For an Executable File That Uses Parameters?  (Thurs. – 6/7/07)
How Can I Add a Page X of Y Footer to a Microsoft Word Document?  (Wed. – 6/6/07)
How Can I Append a Value to a Specified Field For Each Record in a Database?  (Tues. – 6/5/07)
How Can I Copy Selected Columns From a CSV File to an Excel File?  (Mon. – 6/4/07)

Week of June 1st, 2007

How Can I Change the File Extension for All the Files in a Folder?  (Fri. – 6/1/07)
How Can I Wait Until One Application Has Quit Before Starting a Second Application?  (Thurs. – 5/31/07)
How Can I Delete the First Line and the Last Line in a Text File?  (Wed. – 5/30/07)
How Can I Change the Background Color of Spreadsheet Rows That Have a Date in a Specified Cell?  (Tues. – 5/29/07)
Happy Holiday  (Mon. – 5/28/07)

May 2007

Week of May 25th, 2007

How Can I Export an HTA Table to Excel?  (Fri. – 5/25/07)
How Can I Compare the Contents of Two Text Files?  (Thurs. – 5/24/07)
How Can I Save Each Paragraph in a Word Document as a Database Record?  (Wed. – 5/23/07)
How Can I Monitor the Number of Files in a Folder?  (Tues. – 5/22/07)
How Can I Add the Contents of a Group of Text Files to an Access Database?  (Mon. – 5/21/07)

Week of May 18th, 2007

How Can I Search Every Text File in a Folder For Phone Numbers?  (Fri. – 5/18/07)
How Can I Search For Phone Numbers in a Text File?  (Thurs. – 5/17/07)
How Can I Force All the Users in an OU to Change Their Password the Next Time They Log On?  (Wed. – 5/16/07)
How Can I Copy the Same File to a Number of Different Computers?  (Tues. – 5/15/07)
How Can I Dynamically Hide and Show a Control in an HTA?  (Mon. – 5/14/07)

Week of May 11th, 2007

How Can I Highlight a Keyword in an HTA?  (Fri. – 5/11/07)
How Can I Determine the Topmost OU For an Active Directory Object?  (Thurs. – 5/10/07)
How Can I Prevent Users From Typing Anything But Numbers Into an HTA Text Box?  (Wed. – 5/9/07)
How Can I List All the Meetings Scheduled By a Specified Person?  (Tues. – 5/8/07)
How Can I Delete All the Duplicates in a Set of Processes But Keep the Oldest Process?  (Mon. – 5/7/07)

Week of May 4th, 2007

How Can I Replace Single Quote Marks in a Text File?  (Fri. – 5/4/07)
How Can I Determine the Home Directory For All the Disabled User Accounts in Active Directory?  (Thurs. – 5/3/07)
How Can I Ensure That a Script Runs Only Once on a Computer?  (Wed. – 5/2/07)
How Can I Delete All the Worksheets in a Spreadsheet Except for the First Worksheet?  (Tues. – 5/1/07)
How Can I Remove the First Five Lines From All the Log Files in a Folder?  (Mon. – 4/30/07)

April 2007

Week of April 27th, 2007

How Can I Assign a Background Color to Cells in a Spreadsheet and Then “Sum” Those Cells?  (Fri. – 4/27/07)
How Can I Start a Process and Then Log the User Off When That Process Ends?  (Thurs. – 4/26/07)
How Can I Sort a Row in an Excel Spreadsheet?  (Wed. – 4/25/07)
How Can I Get the Command Window to Stay Open When I Right-Click a Script and Choose Open With Command Prompt?  (Tues. – 4/24/07)
How Can I Replace the First Five Characters in a Text File With the First Five Characters in the Computer Name?  (Mon. – 4/23/07)

Week of April 20th, 2007

How Can I Write a Script That Increments a Counter Each Time a Log File is Updated?  (Fri. – 4/20/07)
How Can I Get a List of All the Local Users Who Have an Expiring Password?  (Thurs. – 4/19/07)
How Can I Tell Which Version of QuickTime is Installed on a Computer?  (Wed. – 4/18/07)
How Can I Tack a Prefix Onto the Telephone Numbers of All the Users in My Domain?  (Tues. – 4/17/07)
How Can I Read the Contents of a Text File and Then Declare the Contents as Variables?  (Mon. – 4/16/07)

Week of April 13th, 2007

How Can I Map Drive X on a Computer, But Only If Drive X isn’t Already in Use?  (Fri. – 4/13/07)
How Can I Remove the Password When Opening an Excel Spreadsheet?  (Thurs. – 4/12/07)
How Can I Get a List of All the Users Who Have a Process Open on a Computer?  (Wed. – 4/11/07)
How Can I Filter Outlook Messages By Email Address?  (Tues. – 4/10/07)
How Can I Tell Whether a Laptop Computer is Running Off Batteries?  (Mon. – 4/9/07)

Week of April 6th, 2007

How Can I Let Users Choose a Default Printer From a List of Printers?  (Fri. – 4/6/07)
How Can I Configure an Expiration Date for a Local User Account?  (Thurs. – 4/5/07)
How Can I Import an Excel Spreadsheet Into an Access Database?  (Wed. – 4/4/07)
How Can I Save a Table in an Access Database as a Spreadsheet?  (Tues. – 4/3/07)
How Can I Determine the Grace Period for a Computer Running Windows Vista?  (Mon. – 4/2/07)

March 2007

Week of March 30th, 2007

How Can I Locate a Word in a Text File and Then Echo Back That Word and Any Remaining Text?  (Fri. – 3/30/07)
How Can I Search a Text File for Strings Meeting a Specified Pattern?  (Thurs. – 3/29/07)
How Can I Change the Color of the Scrollbars in an HTA?  (Wed. – 3/28/07)
How Can I List All the Members of a Microsoft Outlook Distribution List?  (Tues. – 3/27/07)
How Can I Use Windows PowerShell to Be Notified When an Application Terminates?  (Mon. – 3/26/07)

Week of March 23rd, 2007

How Can I Parse a Tab-Delimited File and Then Save That as a Comma-Separated Values File?  (Fri. – 3/23/07)
How Can I Determine the Signal Strength of a Wireless Connection?  (Thurs. – 3/22/07)
How Can Users Type Data Into an HTA Without Using Text Boxes?  (Wed. – 3/21/07)
How Can I Map a Drive Based on a User’s Name and OU?  (Tues. – 3/20/07)
How Can I Delete a Desktop Shortcut If I Don’t Know the Shortcut’s File Path?  (Mon. – 3/19/07)

Week of March 16th, 2007

How Can I Force a Specified Letter Case in an HTA?  (Fri. – 3/16/07)
How Can I Format a Series of Numbers as a Phone Number?  (Thurs. – 3/15/07)
How Can I Replace a Specified Font in a Microsoft Word Document?  (Wed. – 3/14/07)
How Can I Use Graphics in an HTA’s Bulleted List?  (Tues. – 3/13/07)
How Can I Determine the Follow-Up Status of Outlook Emails?  (Mon. – 3/12/07)

Week of March 9th, 2007

How Can I Change a Service Description?  (Fri. – 3/9/07)
How Can I Verify the System Time on a Remote Computer?  (Thurs. – 3/8/07)
How Can I Tell If Any of My Contacts Have a Birthday This Month?  (Wed. – 3/7/07)
How Can I Apply a Theme to a Microsoft Word Document?  (Tues. – 3/6/07)
How Can I Count the Number of Characters in a Text File?  (Mon. – 3/5/07)

Week of March 2nd, 2007

How Can I Modify a Text File and Then Extract Selected Lines From the Modified Contents?  (Fri. – 3/2/07)
How Can I Change the First Two Octets of an IP Address?  (Thurs. – 3/1/07)
How Can I Get the Uptime of a Service?  (Wed. – 2/28/07)
How Can I Tally Up All the Words Found in a Text File?  (Tues. – 2/27/07)
How Can I Monitor Event Log Messages for Specific Words?  (Mon. – 2/26/07)

February 2007

Week of February 23rd, 2007

How Can I Add the Last-Saved Date to the Footer of a Microsoft Word Document?  (Fri. – 2/23/07)
How Can I Tell If a Script is Running on the First or Second Monday of a Month?  (Thurs. – 2/22/07)
How Can I Return Information For Each Member in a Group?  (Wed. – 2/21/07)
How Can I Use a Blank Row to Separate Data in an Excel Spreadsheet?  (Tues. – 2/20/07)
How Can I Specify the Number of Decimal Places to Display in an Excel Spreadsheet?  (Mon. – 2/19/07)

Week of February 16th, 2007

How Can I Insert Text Into a “Bookmark” in a Text File?  (Fri. – 2/16/07)
How Can I Get the Full Name of a Windows NT 4.0 User When All I Have is Their Logon Name?  (Thurs. – 2/15/07)
How Can I Automatically Open New Files Added to a Folder?  (Wed. – 2/14/07)
How Can I Change the Last Modified Timestamp for All the Files in a Folder?  (Tues. – 2/13/07)
How Can I Configure Excel to Autosave Every 5 Minutes?  (Mon. – 2/12/07)

Week of February 9th, 2007

How Can I Log a User Off After 5 Minutes of Inactivity?  (Fri. – 2/9/07)
How Can I Save an Excel Chart as a Picture?  (Thurs. – 2/8/07)
How Can I Prompt a User for Information and Then Pass That Information to a Command-Line Tool?  (Wed. – 2/7/07)
How Can I Import a .CSV File into an Access Database?  (Tues. – 2/6/07)
How Can I Specify the Tab Order in an HTA?  (Mon. – 2/5/07)

Week of February 2nd, 2007

How Can I Use Windows PowerShell to Get a List of All the Open Windows on a Computer?  (Fri. – 2/2/07)
How Can I Delete All the Messages in My Sent Items Folder?  (Thurs. – 2/1/07)
How Can I Change the Font Color in Excel If a Specified Condition is Met?  (Wed. – 1/31/07)
How Can I Determine the Default Buffer Size for the Command Window?  (Tues. – 1/30/07)
How Can I Delete All the .CSG Files on Drive C of a Computer?  (Mon. – 1/29/07)

January 2007

Week of January 26th, 2007

How Can I Get a List of All the Subfolders in a Folder and Then Put That List Into an Array?  (Fri. – 1/26/07)
How Can I Convert an Excel Spreadsheet to XML?  (Thurs. – 1/25/07)
How Can I Start Outlook If It Isn’t Already Running?  (Wed. – 1/24/07)
How Can I Get the Name of the Last User to Log on to a Computer?  (Tues. – 1/23/07)
How Can I Create A New Folder Using a Name Based on the Current Date?  (Mon. – 1/22/07)

Week of January 19th, 2007

How Can I Insert a Date Field in Word?  (Fri. – 1/19/07)
How Can I Change the Desktop Wallpaper to One of Six Pre-defined Selections?  (Thurs. – 1/18/07)
How Can I Delete Just the IP Addresses From Each Line in a Text File?  (Wed. – 1/17/07)
How Can I Set the Default File Path in Excel to a User’s Home Directory?  (Tues. – 1/16/07)
How Can I List All the Groups in a Windows NT 4.0 Domain?  (Mon. – 1/15/07)

Week of January 12th, 2007

How Can I Subtract Days From a UTC Date-Time Value in Windows 2000?  (Fri. – 1/12/07)
How Can I Take Action Based on the First Line of a Text File?  (Thurs. – 1/11/07)
How Can I Retrieve the Subject Property for a .MSI File?  (Wed. – 1/10/07)
How Can I Add a New Item to the Microsoft Word AutoCorrect List?  (Tues. – 1/9/07)
How Can I Determine the Version of DirectX Installed on a Computer?  (Mon. – 1/8/07)

Week of January 5th, 2007

How Can I Get the “Date Picture Taken” Property From a .JPG File?  (Fri. – 1/5/07)
How Can I Number the Lines in a Text File?  (Thurs. – 1/4/07)
How Can I Clear All the Formatting From a Microsoft Word Document?  (Wed. – 1/3/07)
How Can I Append a Blank Line to a Text File, Then Append the Current Date and Time?  (Tues. – 1/2/07)
Happy Holiday (Monday 1/1/07)

December 2006

Week of December 29th, 2006

Happy Holiday (Monday 12/25/06 – Friday 12/29/06)

Week of December 22nd, 2006

Happy Holiday (Monday 12/18/06 – Friday 12/22/06)

Week of December 15th, 2006

How Can I List All the Access Database Files on a Computer?  (Fri. – 12/15/06)
How Can I Set a User’s Password and Then Require Them to Change That Password the Next Time They Logon?  (Thurs. – 12/14/06)
How Can I Create a Shortcut That Opens Internet Explorer With the Address Bar Hidden?  (Wed. – 12/13/06)
How Can I Add a Network Printer at Logon and, Optionally, Make That the Default Printer?  (Tues. – 12/12/06)
How Can I Copy My Users’ Phone Number Attribute to Their Description Attribute?  (Mon. – 12/11/06)

Week of December 8th, 2006

How Can I Start a Process and Then Wait For the Process to End Before Terminating the Script?  (Fri. – 12/8/06)
How Can I Compare a List of Names in One Excel Column to a List of Names in Another Column?  (Thurs. – 12/7/06)
How Can I Determine the OU the Local Computer Belongs To?  (Wed. – 12/6/06)
How Can I Convert a Tilde-Delimited File to Microsoft Excel Format?  (Tues. – 12/5/06)
How Can I Expand the Width of the Windows PowerShell Console?  (Mon. – 12/4/06)

Week of December 1st, 2006

How Can I Search Active Directory for User Names Stored in an Excel Spreadsheet?  (Fri. – 12/1/06)
How Can I Read the Individual Lines in a Multi-Line Text Box?  (Thurs. – 11/30/06)
How Can I Change the Text for the Marquee Screen Saver?  (Wed. – 11/29/06)
How Can I Rename a Folder?  (Tues. – 11/28/06)
How Can I Position the Cursor in a Specific Text Box Each Time I Start an HTA?  (Mon. – 11/27/06)

November 2006

Week of November 24th, 2006

Happy Holiday (Friday – 11/24/06)
Happy Holiday (Thursday – 11/23/06)
How Can I Locate a Value in a Text File and Then Parse the Line of Text Where the Value Was Found?  (Wed. – 11/22/06)
How Can I Add a Function to a Windows PowerShell Script?  (Tues. – 11/21/06)
How Can I Add a User to a Group If I Don’t Know the Distinguished Name of That User?  (Mon. – 11/20/06)

Week of November 17th, 2006

How Can I Delete All the .BAK Files in a Folder That Are More Than 7 Days Old?  (Fri. – 11/17/06)
How Can I Create a New Registry Key?  (Thurs. – 11/16/06)
How Can I Add a Total Row to an Excel Spreadsheet?  (Wed. – 11/15/06)
How Can I Extract Information Located Between Two Known Values in a Text File?  (Tues. – 11/14/06)
How Can I Map a Drive, Copy a File to That Drive, and Then Unmap the Drive?  (Mon. – 11/13/06)

Week of November 10th, 2006

How Can I Change the Default Highlight Color for a Microsoft Word Document?  (Fri. – 11/10/06)
How Can I Use Windows PowerShell to Get a List of All My Computers?  (Thurs. – 11/9/06)
How Can I Create a Custom Date Format in Microsoft Excel?  (Wed. – 11/8/06)
How Can I Separate Hours and Minutes in a Date-Time Value?  (Tues. – 11/7/06)
How Can I Extract the Text Between the Header and Footer in a Text File?  (Mon. – 11/6/06)

Week of November 3rd, 2006

How Can I Run a Macro After Opening Up Word?  (Fri. – 11/3/06)
How Can I Enable System Restore Using a Script?  (Thurs. – 11/2/06)
How Can I Keep the Screen From Updating While Running an Excel Script?  (Wed. – 11/1/06)
How Can I Configure an Active Directory Account So the Password Never Expires?  (Tues. – 10/31/06)
How Can I Use Information in an Excel Spreadsheet to Rename a Set of Folders?  (Mon. – 10/30/06)

October 2006

Week of October 27th, 2006

How Can I Delete Duplicate Items From an Array?  (Fri. – 10/27/06)
How Can I Center-Align a Picture in a Word Document?  (Thurs. – 10/26/06)
How Can I Repeatedly Prompt a User to Enter a File Name?  (Wed. – 10/25/06)
How Can I Connect to the Junk Mail Folder in Outlook?  (Tues. – 10/24/06)
How Can I Use Windows PowerShell to Delete All the .TMP Files on a Drive?  (Mon. – 10/23/06)

Week of October 20th, 2006

How Can I Print a Microsoft Access Report?  (Fri. – 10/20/06)
How Can I Tell Whether a Number is Even or Odd?  (Thurs. – 10/19/06)
How Can I Split a String Only on Specific Instances of a Character?  (Wed. – 10/18/06)
How Can I Clear the Contents of Any File Dropped on My Script Icon?  (Tues. – 10/17/06)
How Can I Create a Table in a SQL Server Database?  (Mon. – 10/16/06)

Week of October 13th, 2006

How Can I Change an Existing Hyperlink in a Microsoft Word Document?  (Fri. – 10/13/06)
How Can I Make Sure That No Line in a Text File Exceeds 261 Characters?  (Thurs. – 10/12/06)
How Can I Delete a Record From a Disconnected Recordset?  (Wed. – 10/11/06)
How Can I Provide a Visual Indicator When Copying Files?  (Tues. – 10/10/06)
How Can I Compact an Access Database?  (Mon. – 10/9/06)

Week of October 6th, 2006

How Can I Pass a Drive Letter From a Script to the Command Shell?  (Fri. – 10/6/06)
How Can I Tell Whether a Specified Table Exists in a SQL Server Database?  (Thurs. – 10/5/06)
How Can I Monitor for the Creation of Different Processes?  (Wed. – 10/4/06)
How Can I Add a Blank Line Between the Existing Paragraphs in a Word Document?  (Tues. – 10/3/06)
How Can I Use Windows PowerShell to Pull Records From a Microsoft Access Database?  (Mon. – 10/2/06)

September 2006

Week of September 29th, 2006

How Can I Determine Whether Terminal Services is Enabled on a Windows Server 2003 Computer?  (Fri. – 9/29/06)
How Can I Locate Strings That Consist of a Series of Numbers Followed by .ZIP?  (Thurs. – 9/28/06)
How Can I Determine the Background Color of a Spreadsheet Cell?  (Wed. – 9/27/06)
How Can I Run a Windows PowerShell Script from the Run Dialog Box or a Shortcut?  (Tues. – 9/26/06)
How Can I Insert Text Into an Existing Microsoft Word Bookmark?  (Mon. – 9/25/06)

Week of September 22nd, 2006

How Can I Verify That All the Items in a List Also Appear in Another List?  (Fri. – 9/22/06)
How Can I Make the First Character in a Cell Uppercase and All the Other Characters Lowercase?  (Thurs. – 9/21/06)
How Can I Verify That All the Characters in a String are Either A-to-Z (Uppercase Letters) or the Digits 0-through-9?  (Wed. – 9/20/06)
How Can I Locate All the Folders That Have \Archive\ASN\ in the Path?  (Tues. – 9/19/06)
How Can I Copy a Worksheet to a New Spreadsheet?  (Mon. – 9/18/06)

Week of September 15th, 2006

How Can I Tell if Any Internet Explorer Windows Are Open to a Particular Web Site?  (Fri. – 9/15/06)
How Can I Get a List of All the Databases on a SQL Server Computer?  (Thurs. – 9/14/06)
How Can I Delete All the Users in an Active Directory Group?  (Wed. – 9/13/06)
How Can I Identify the Last File in a Sequential List of Files?  (Tues. – 9/12/06)
How Can I Delete Just the Last Line of a Text File?  (Mon. – 9/11/06)

Week of September 8th, 2006

How Can I Use Windows PowerShell to Automate Microsoft Excel?  (Fri. – 9/8/06)
How Can I Get a Total Page Count for All the Word Documents in a Folder?  (Thurs. – 9/7/06)
How Can I Alternate Row Colors in an HTA?  (Wed. – 9/6/06)
How Can I Run a PowerPoint Slide Show From a Script?  (Tues. – 9/5/06)
Happy Holiday (Monday – 9/4/06)

Week of September 1st, 2006

How Can I Tell Which Numbers Are Missing From a Sequence of Numbers Found in a Text File?  (Fri. – 9/1/06)
How Can I Set the Document Orientation in Microsoft Word to Landscape?  (Thurs. – 8/31/06)
How Can I Use Windows PowerShell to Locate All the .WMA Files on My Computer?  (Wed. – 8/30/06)
How Can I Cause a Script to Run Inside an HTA Any Time a User Presses ENTER?  (Tues. – 8/29/06)
How Can I Append a Location to the Path Environment Variable?  (Mon. – 8/28/06)

August 2006

Week of August 25th, 2006

How Can I Determine the First Friday in a Month?  (Fri. – 8/25/06)
How Can I Add or Subtract Two Hexadecimal Numbers?  (Thurs. – 8/24/06)
How Can I Use Windows PowerShell to Determine the Status of the Guest Account?  (Wed. – 8/23/06)
How Can I Dynamically Change the Background Color of an HTA?  (Tues. – 8/22/06)
How Can I Save a File Based on the Day of the Week?  (Mon. – 8/21/06)

Week of August 18th, 2006

How Can I Minimize or Hide an HTML Application for 30 Seconds?  (Fri. – 8/18/06)
How Can I Modify the Output of the Ping Command?  (Thurs. – 8/17/06)
How Can I Remove Blank Spaces From File Names?  (Wed. – 8/16/06)
How Can I Remove Double Double Quotes From a Text File?  (Tues. – 8/15/06)
How Can I List All the Printers on a Remote Computer?  (Mon. – 8/14/06)

Week of August 11th, 2006

How Can I Determine the Name of a Script While That Script is Running?  (Fri. – 8/11/06)
How Can Tell Whether the NumLock Key is On or Off?  (Thurs. – 8/10/06)
How Can I Concatenate Files of the Same Name?  (Wed. – 8/9/06)
How Can I Replace Text in a Microsoft Word Document?  (Tues. – 8/8/06)
How Can I Tell Whether a Phrase Occurs At Least Twice in a Text File?  (Mon. – 8/7/06)

Week of August 4th, 2006

How Can I Determine Whether a Domain is in Mixed Mode or Native Mode?  (Fri. – 8/4/06)
How Can I Get Access to a Mail Folder That Isn’t a Subfolder of My Outlook Inbox?  (Thurs. – 8/3/06)
How Can I Get a List of All the Senders’ Email Addresses in an Outlook Folder?  (Wed. – 8/2/06)
How Can I Retrieve Information Required by the Sarbanes-Oxley Act?  (Tues. – 8/1/06)
How Can I Incrementally Rename All the Files in a Folder?  (Mon. – 7/31/06)

July 2006

Week of July 28th, 2006

How Can I Get the Process ID for an Executable File, But Only If the Process Has a Specified Owner?  (Fri. – 7/28/06)
How Can I Display a Message Box That Has No Buttons, and That Disappears After a Specified Period of Time?  (Thurs. – 7/27/06)
How Can I Move the Oldest File in a Folder to a Different Folder?  (Wed. – 7/26/06)
How Can I Delete All the Email Sent From a Specific Person?  (Tues. – 7/25/06)
How Can I Replace Selected Lines in an XML File?  (Mon. – 7/24/06)

Week of July 21st, 2006

How Can I Subtract a Specified Number of Days from a UTC Value?  (Fri. – 7/21/06)
How Can I Tell If a Specified Worksheet Exists in an Excel Workbook?  (Thurs. – 7/20/06)
How Can I Set the Default Printer Based on the IP Address of the Computer?  (Wed. – 7/19/06)
How Can I Create a Logon Script That Will Open a User’s Mapped Drives?  (Tues. – 7/18/06)
How Can I Get the Names of 10 Randomly-Selected Files in a Folder?  (Mon. – 7/17/06)

Week of July 14th, 2006

How Can I Search For (and Reformat) Highlighted Text in a Word Document?  (Fri. – 7/14/06)
How Can I Add a COUNTIF Formula to an Excel Spreadsheet?  (Thurs. – 7/13/06)
How Can I Determine Last Month’s Date?  (Wed. – 7/12/06)
How Can I Load List Box Options From a Text File?  (Tues. – 7/11/06)
How Can I List All the Empty Folders on a Specified Drive?  (Mon. – 7/10/06)

Week of July 7th, 2006

How Can I Determine Whether or Not My Local Users are Required to Have a Password?  (Fr. – 7/7/06)
How Can I Create a Compressed Folder and Add Files to It?  (Thurs. – 7/6/06)
How Can I Test a Dynamic Array to See if the Array is Empty?  (Wed. – 7/5/06)
Happy Holiday (Tuesday – 7/4/06)
How Can I Get the Full Name and Description For My Local User Accounts?  (Mon. – 7/3/06)

June 2006

Week of June 30th, 2006

How Can I Locate All the Instances of a Particular File on a Computer?  (Fr. – 6/30/06)
How Can I Bind to an Active Directory User Account Using Windows PowerShell?  (Thurs. – 6/29/06)
How Can I Get a List of the Unique Words Used in a Microsoft Word Document?  (Wed. – 6/28/06)
How Can I Copy a File 150 Times?  (Tues. – 6/27/06)
How Can I Copy All the Comments From an Excel Worksheet to a Word Document?  (Mon. – 6/26/06)

Week of June 23rd, 2006

How Can I Move a Computer From an Unknown OU into a Known OU?  (Fri. – 6/23/06)
How Can I Determine Whether a File Exists on a Remote Computer?  (Thurs. – 6/22/06)
How Can I Use Windows PowerShell to Start a Service on a Remote Computer?  (Wed. – 6/21/06)
How Can I Retrieve a List of All the Files That Have No File Extension?  (Tues. – 6/20/06)
How Can I Write a Script That Prevents the Screensaver from Starting?  (Mon. – 6/19/06)

Week of June 16th, 2006

How Can I Write a Script That Accesses All the Subfolders in My Outlook Inbox?  (Fri. – 6/16/06)
How Can I Insert Text Into a Specific Column of a Text File?  (Thurs. – 6/15/06)
How Can I Get a List of Available Metadata for Microsoft Office Documents?  (Wed. – 6/14/06)
How Can I Populate a List Box With the CNs of All the OUs in My Domain?  (Tues. – 6/13/06)
How Can I Add a Right-to-Left Text Box to a Web Page?  (Mon. – 6/12/06)

Week of June 9th, 2006

How Can I Add Multiple Tables to a Word Document?  (Fri. – 6/906)
How Can I List All the Tables in an Access Database?  (Thurs. – 6/8/06)
How Can I Add Leading Zeroes to All the Lines in a Text File?  (Wed. – 6/7/06)
How Can I Return the URLs Associated with My Internet Explorer Favorites?  (Tues. – 6/6/06)
How Can I Dynamically Add Controls to an HTA?  (Mon. – 6/5/06)

Week of June 2nd, 2006

How Can I Configure the System Failure Options on a Windows Server 2003 Computer?  (Fri. – 6/2/06)
How Can I Find the Process ID Associated with a Batch File?  (Thurs. – 6/1/06)
How Can I Search a Word Document for All the Words in Double Brackets?  (Wed. – 5/31/06)
How Can I Extract Just the File Name from the Full Path to the File?  (Tues. – 5/30/06)
Happy Holiday (Monday – 5/29/06)

May 2006

Week of May 26th, 2006

How Can I Search for Folders That Have a Dot in Their Name?  (Fri. – 5/26/06)
How Can I Change All the Lowercase Letters in an Excel Worksheet to Uppercase Letters?  (Thurs. – 5/25/06)
How Can I Get a Script to Delete Itself?  (Wed. – 5/24/06)
How Can I Rename a User Account in a Windows NT 4.0 Domain?  (Tues. – 5/23/06)
How Can I Get a List of All the .dll Files in a Folder, Along with Their Version Numbers?  (Mon. – 5/22/06)

Week of May 19th, 2006

How Can I Hide the Command Window When Executing a Command Like Net Localgroup Administrators?  (Fri. – 5/19/06)
How Can I Create a New Excel Spreadsheet at Midnight Each Night?  (Thurs. – 5/18/06)
How Can I Rename a Local User Account on a Windows XP Computer?  (Wed. – 5/17/06)
How Can I Use a Script to Create a Sequential Series of User Accounts?  (Tues. – 5/16/06)
How Can I Tell Whether a .GIF File is a Regular Picture File or an Animated Picture File?  (Mon. – 5/15/06)

Week of May 12th, 2006

How Can I Convert a Global Security Group to a Universal Security Group?  (Fri. – 5/12/06)
How Can I Rename Files Using File Names I’ve Written to a Text File?  (Thurs. – 5/11/06)
How Can I Add Centered Page Numbers to the Footer of a Word Document?  (Wed. – 5/10/06)
How Can I Clear the List of URLs That Appear in the Internet Explorer Address Bar?  (Tues. – 5/9/06)
How Can I Map Network Drives Based on a Computer’s Site?  (Mon. – 5/8/06)

Week of May 5th, 2006

How Can I Force Users to Type Command-line Arguments in a Specific Order?  (Fri. – 5/5/06)
How Can I Query a Text File and Retrieve Records That Occurred on a Specific Date?  (Thurs. – 5/4/06)
How Can I Remove Blank Spaces Before and After a String Value?  (Wed. – 5/3/06)
How Can I Use a Script to Automatically Queue Up Files That I Want to Burn to a CD?  (Tues. – 5/2/06)
How Can I Determine the Size of All the Items Currently in the Recycle Bin?  (Mon. – 5/1/06)

April 2006

Week of April 28th, 2006

How Can I Use the RunAs Command to Run a Script Under Alternate User Credentials?  (Fri. – 4/28/06)
How Can I Print Just the Text Area of an HTA?  (Thurs. – 4/27/06)
How Can I Get a List of All My Internet Cookies?  (Wed. – 4/26/06)
How Can I Determine the Name of the Local Computer Using WMI?  (Tues. – 4/25/06)
How Can I Select a Column of Data in Excel and Then Paste that Data into a Text File?  (Mon. – 4/24/06)

Week of April 21st, 2006

How Can I Reformat Numbers Using a Script?  (Fri. – 4/21/06)
How Can I Tell Which of Our Windows Server 2003 Computers are Running R2?  (Thurs. – 4/20/06)
How Can I Open a Text File as Unicode?  (Wed. – 4/19/06)
How Can I Add an Edit Command to the Context Menu for an HTA?  (Tues. – 4/18/06)
How Can I Change the Title Property of a .WMA File?  (Mon. – 4/17/06)

Week of April 14th, 2006

How Can I Tell Whether a Computer has a Specific CD in It?  (Fri. – 4/14/06)
How Can I Distinguish Between Local Users and Domain Users?  (Thurs. – 4/13/06)
How Can I Create a Table and Fill the First Column With a Range of Dates?  (Wed. – 4/12/06)
How Can I Save a Disconnected Recordset?  (Tues. – 4/11/06)
How Can I List All the Files on a User’s Desktop?  (Mon. – 4/10/06)

Week of April 7th, 2006

How Can I Convert a Number to a Date in Excel?  (Fri. – 4/7/06)
How Can I Locate and Replace Information for a Specific Item in a Spreadsheet?  (Thurs. – 4/6/06)
How Can I Determine the Path to the Folder Where a Script is Running?  (Wed. – 4/5/06)
How Can I Rename a Word Document Using the First Three Characters in That Document?  (Tues. – 4/4/06)
How Can I Count the Number of Words in a Text File?  (Mon. – 4/3/06)

March 2006

Week of March 31st, 2006

How Can I Use a Script to Lock the Taskbar?  (Fri. – 3/31/06)
How Can I Temporarily Pause a Script in an HTA?  (Thurs. – 3/30/06)
How Can I Change the IP Address Assigned to a Computer?  (Wed. – 3/29/06)
How Can I Disable the Keep Printed Documents Attribute on a Printer?  (Tues. – 3/28/06)
How Can I Determine the Default Script Host on a Computer Before I Run a Script?  (Mon. – 3/27/06)

Week of March 24th, 2006

How Can I Retrieve a List of the Commands Typed Into the Run Dialog Box?  (Fri. – 3/24/06)
How Can I Write a Script That Will Open a Text File and Shuffle the Words Found in That File?  (Thurs. – 3/23/06)
How Can I Get a List of All the Users Who Have an Alternate Recipient?  (Wed. – 3/22/06)
How Can I Search for and Highlight Words in a Microsoft Word Document?  (Tues. – 3/21/06)
How Can I Get a List of Installed Device Drivers?  (Mon. – 3/20/06)

Week of March 17th, 2006

How Can I Start Windows Explorer Opened to a Specific Folder?  (Fri. – 3/17/06)
How Can I Determine the Local Path to a Shared Folder?  (Thurs. – 3/16/06)
How Can I Delete a Folder That Has an Apostrophe in the Name?  (Wed. – 3/15/06)
How Can I Determine the Drive Label of a Drive?  (Tues. – 3/14/06)
How Can I Write Output to the Screen that Overwrites Whatever is Currently on the Screen?  (Mon. – 3/13/06)

Week of March 10th, 2006

How Can I Set Scriptomatic So That It Automatically Outputs to a Text File?  (Fri. – 3/10/06)
How Can I Encode Scripts Within an HTA?  (Thurs. – 3/9/06)
How Can I Configure the Screensaver Used When No One is Logged On to a Computer?  (Wed. – 3/8/06)
How Can I Save an Excel Spreadsheet, and Then Save a Copy as HTML?  (Tues. – 3/7/06)
How Can I Change the Internet Explorer Title Bar?  (Mon. – 3/6/06)

Week of March 3rd, 2006

How Can I Read Just the Last Line of a Text File?  (Fri. – 3/3/06)
How Can I Determine if a Computer is Running Windows Server 2003 and if Service Pack 1 is Installed?  (Thurs. – 3/2/06)
How Can I Right-Align a Single Column in a Word Table?  (Wed. – 3/1/06)
How Can I Re-Launch Internet Explorer if No Other Instances are Running?  (Tues. – 2/28/06)
How Can I Disable a Service?  (Mon. – 2/27/06)

February 2006

Week of February 24th, 2006

How Can I Prevent a Computer from Using the LMHosts File?  (Fri. – 2/24/06)
How Can I Format an Excel Spreadsheet So It Retains Leading Zeroes?  (Thurs. – 2/23/06)
How Can I Truncate Names to a Maximum of 16 Characters?  (Wed. – 2/22/06)
How Can I Replace a Local File with a Newer Version Found on a File Server?  (Tues. – 2/21/06)
How Can I List All the Items in the Run Key in the Registry?  (Mon. – 2/20/06)

Week of February 17th, 2006

How Can I Specify the Computers a User Can Use to Log On to the Domain?  (Fri. – 2/17/06)
How Can I Determine Which Account a Script is Running Under?  (Thurs. – 2/16/06)
How Can I Determine the Last Row in an Excel Spreadsheet?  (Wed. – 2/15/06)
How Can I Convert a DN to this Format: finance.fabrikam.com/Users?  (Tues. – 2/14/06)
How Can I Determine When a Removable Drive Gets Connected?  (Mon. – 2/13/06)

Week of February 10th, 2006

How Can I Log the Start Time and the End Time of the Screensaver?  (Fri. – 2/10/06)
How Can I Count the Number of Times a Word Appears in a Log File?  (Thurs. – 2/9/06)
How Can I Determine Whether a Computer Has Any USB 2.0 Ports?  (Wed. – 2/8/06)
How Can I Determine the Drive Letter for the Drive My Script is Currently Running On?  (Tues. – 2/7/06)
How Can I Assign a New Home Drive to a User Who Doesn’t Have One?  (Mon. – 2/6/06)

Week of February 3rd, 2006

How Can I Search for Multiple File Extensions in a Single WQL Query?  (Fri. – 2/3/06)
How Can I Remove All the Formatting from an Excel Spreadsheet?  (Thurs. – 2/2/06)
How Can I Boldface a Specific Word Throughout a Microsoft Word Document?  (Wed. – 2/1/06)
How Can I Retrieve Information About the Latest Event Added to an Event Log?  (Tues. – 1/31/06)
How Can I Find the Date of the Oldest Event in an Event Log?  (Mon. – 1/30/06)

January 2006

Week of January 27th, 2006

How Can I Count the Number of Computers in a Domain?  (Fri. – 1/27/06)
How Can I Auto-Delete Specific File Types from the My Pictures Folder?  (Thurs. – 1/26/06)
How Can I Get a List of All the Objects that have been Added to Active Directory Since a Specified Date?  (Wed. – 1/25/06)
How Can I Display the IP Addresses Associated with a Given MAC Address?  (Tues. – 1/24/06)
How Can I Add a User to a Group, but Only if that User is a Member of the IT Department?  (Mon. – 1/23/06)

Week of January 20th, 2006

How Can I Extract a Series of Characters Found in the Middle of a String?  (Fri. – 1/20/06)
How Can I Tell Which Users are Connected to a Print Queue?  (Thurs. – 1/19/06)
How Can I Change the Size of a Page File?  (Wed. – 1/18/06)
How Can I Tell Whether a Logon Script is Running on a Workstation or on a Server?  (Tues. – 1/17/06)
How Can I Get Total Size and Number of Items in an Outlook Folder?  (Mon. – 1/16/06)

Week of January 13th, 2006

How Can I List All the Sub-OUs in an OU?  (Fri. – 1/13/06)
How Can I Determine Which Day of the Year a Date Falls On?  (Thurs. – 1/12/06)
How Can I Take Ownership of a File or Folder By Using a Script?  (Wed. – 1/11/06)
How Can I Change the Font Name and Size for an Entire Word Document?  (Tues. – 1/10/06)
How Can I Remove All the Black-and-White Printers on a Computer?  (Mon. – 1/9/06)

Week of January 6th, 2006

How Can I Determine Which Text has been Selected in an HTA?  (Fri. – 1/6/06)
How Can I Purge a Print Queue on a Print Server?  (Thurs. – 1/5/06)
How Can I Move All the Users from One OU to Another OU?  (Wed. – 1/4/06)
How Can I Remove All the Blank Lines from a Text File?  (Tues. – 1/3/06)

December 2005

Week of December 23rd, 2005

Happy Holidays (Fri. – 12/23/05) – Next column January 3, 2006
How Can I Retrieve the Path to the Program Files Folder on a Computer?  (Thurs. – 12/22/05)
How Can I Change the Footer in an Excel Spreadsheet?  (Wed. – 12/21/05)
How Can I Get the “Grandparent” of an Object in Active Directory?  (Tues. – 12/20/05)
How Can I Delete the C$ Share from a Computer?  (Mon. – 12/19/05)

Week of December 16th, 2005

How Can I Create an HTA that Doesn’t Have a Close Button in the Title Bar?  (Fri. – 12/16/05)
How Can I Add Additional Worksheets to an Excel Workbook?  (Thurs. – 12/15/05)
How Can I Configure the History Setting in Internet Explorer?  (Wed. – 12/14/05)
How Can I Disable a Computer Account?  (Tues. – 12/13/05)
How Can I Delete Everyone Except the Administrator and the Domain Admins Group from the Local Administrators Group?  (Mon. – 12/12/05)

Week of December 9th, 2005

How Can I Use Alternate Credentials When Searching Active Directory?  (Fri. – 12/9/05)
How Can I Convert Names to Proper Case?  (Thurs. – 12/8/05)
How Can I Change the Description for a Computer?  (Wed. – 12/7/05)
How Can I Print Text Files to a Printer Other than the Default Printer?  (Tues. – 12/6/05)
How Can I Convert an Outlook Email Message into a Text File?  (Mon. – 12/5/05)

Week of December 2nd, 2005

How Can I Change the Location of a User’s Home Drive in Active Directory?  (Fri. – 12/2/05)
How Can I Remove All the Local Printers from a Computer?  (Thurs. – 12/1/05)
How Can I Close a Command Window with a Specific Title?  (Wed. – 11/30/05)
How Can I Set Word’s Revision View Mode to Final?  (Tues. – 11/29/05)
How Can I Rename Files Like _JKG1234.jpg to 272_DSC_1234.jpg?  (Mon. – 11/28/05)

November 2005

Week of November 25th, 2005

Happy Holiday (Fri. – 11/25/05)
Happy Holiday (Thurs. – 11/24/05)
How Can I Get a List of All the Groups Whose Name Starts with G-S-Group?  (Wed. – 11/23/05)
How Can I Sort Worksheets in a Workbook?  (Tues. – 11/22/05)
How Can I Lock a Workstation After Five Minutes of Inactivity?  (Mon. – 11/21/05)

Week of November 18th, 2005

How Can I Verify that ADAM is Installed?  (Fri. – 11/18/05)
How Can I Import a Fixed-Width File into Microsoft Excel?  (Thurs. – 11/17/05)
How Can I Determine the Height and Width of a Picture File Without Using Windows Media Player?  (Wed. – 11/16/05)
How Can I Use ADO to Read a Text File Where All the Data is on a Single Line?  (Tues. – 11/15/05)
How Can I Tell if ActiveX is Enabled in Internet Explorer?  (Mon. – 11/14/05)

Week of November 11th, 2005

How Can I Get the Command Window to Stay Open After Running a Command-Line Tool?  (Fri. – 11/11/05)
How Can I Receive Notification Any Time Something is Printed to a Particular Printer?  (Thurs. – 11/10/05)
How Can I Clear an HTA Window?  (Wed. – 11/9/05)
How Can I Insert Multiple Files Into a Word Document, Putting a Page Break Between Each File?  (Tues. – 11/8/05)
How Can I List All the Sites in Active Directory as well as All the Servers in Those Sites?  (Mon. – 11/7/05)

Week of November 4th, 2005

How Can I Add a Hyperlink to an Excel Spreadsheet?  (Fri. – 11/4/05)
How Can I Determine the ADsPath for the Logged-On User?  (Thurs. – 11/3/05)
How Can I Determine the Name of the Local Administrators Group?  (Wed. – 11/2/05)
How Can I Change a User’s sAMAccountName?  (Tues. – 11/1/05)
How Can I Start an Application From an HTA?  (Mon. – 10/31/05)

October 2005

Week of October 28th, 2005

How Can I Determine an Attribute’s Data Type and Whether It is Single- or Multi-Valued?  (Fri. – 10/28/05)
How Can I Determine Which Drives are Mapped to Network Shares?  (Thurs. – 10/27/05)
How Can I Determine if an OU is Blocking Group Policy Inheritance?  (Wed. – 10/26/05)
How Can I Delete a Backup File Created on the Previous Day?  (Tues. – 10/25/05)
How Can I Remove a Group from the Local Administrators Group?  (Mon. – 10/24/05)

Week of October 21st, 2005

How Can I Read a Text File on a Remote Computer?  (Fri. – 10/21/05)
How Can I Verify That a Folder Has Files in It and, If So, Delete Those Files?  (Thurs. – 10/20/05)
How Can I Configure the Hide From Exchange Address Lists Property for All the Contacts in a Domain?  (Wed. – 10/19/05)
How Can I Add the Last Lines from a Group of Text Files to a Word Document?  (Tues. – 10/18/05)
How Can I List All the Users in an NT 4.0 Domain?  (Mon. – 10/17/05)

Week of October 14th, 2005

How Can I Add a User to a Group if That User Belongs to Two Other Groups?  (Fri. – 10/14/05)
How Can I Get a List of All the Users in an OU and Its Sub-OUs?  (Thurs. – 10/13/05)
How Can I Build an Array from a Column of Data in Excel?  (Wed. – 10/12/05)
How Can I Determine Which Users are Using the Most Disk Space on a Drive?  (Tues. – 10/11/05)
How Can I Center an HTA on the Screen?  (Mon. – 10/10/05)

Week of October 7th, 2005

How Can I Determine Which Version of Access was Used to Create a Database?  (Fri. – 10/7/05)
How Can I Verify that None of My Local User Accounts have a Blank Password?  (Thurs. – 10/6/05)
How Can I Set Word’s Default File Location to be the User’s Home Directory?  (Wed. – 10/5/05)
How Can I Get a Script to Close an HTML Page?  (Tues. – 10/4/05)
How Can I List All the Files in a Folder, Ordered By Creation Date?  (Mon. – 10/3/05)

September 2005

Week of September 30th, 2005

How Can I Determine if a Particular Patch is Installed?  (Fri. – 9/30/05)
How Can I Determine the Logon Name for a User?  (Thurs. – 9/29/05)
How Can I Find All the Drives Mapped to a Share and Remap Them?  (Wed. – 9/28/05)
How Can I Periodically Refresh a Web Page?  (Tues. – 9/27/05)
How Can I Delete Specific Files in a Specific Folder?  (Mon. – 9/26/05)

Week of September 23rd, 2005

How Can I Add a Domain Group to the Local Administrators Group?  (Fri. – 9/23/05)
How Can I Monitor the Activity Level of a Process?  (Thurs. – 9/22/05)
How Can I List All the Groups in an OU?  (Wed. – 9/21/05)
How Can I Copy Column C of One Worksheet to Column A of a Second Worksheet?  (Tues. – 9/20/05)
How Can I Specify a Window Size for My HTA?  (Mon. – 9/19/05)

Week of September 16th, 2005

How Can I Turn Off the Windows XP Service Pack 2 Firewall?  (Fri. – 9/16/05)
How Can I Use a Logon Script to Remove All Mapped Drives?  (Thurs. – 9/15/05)
How Can I Open Word with the Cursor Positioned at the Start of a Specified Line?  (Wed. – 9/14/05)
How Can I Retrieve Just Audit Failures, Warnings, and Errors from My Event Logs?  (Tues. – 9/13/05)
How Can I Center Text in an Excel Cell?  (Mon. – 9/12/05)

Week of September 9th, 2005

How Can I Remove an Item from a List Box in an HTA?  (Fri. – 9/9/05)
How Can I Clear the Logon Script Path for All My Users?  (Thurs. – 9/8/05)
How Can I Check to See if a User Exists in an NT 4 Domain?  (Wed. – 9/7/05)
How Can I Remotely Start an Interactive Process?  (Tues. – 9/6/05)
Happy Holiday (Mon. – 9/5/05)

Week of September 2nd, 2005

How Can I Return a List of All the Users Whose User Account Never Expires?  (Fri. – 9/2/05)
How Can I Add a Shortcut to the Quick Launch Tray?  (Thurs. – 9/1/05)
How Can I Change a User’s Primary Group?  (Wed. – 8/31/05)
How Can I Increment the Last Line in a Text File?  (Tues. – 8/30/05)
How Can I Get a List of All the Users Whose Passwords Never Expire?  (Mon. – 8/29/05)

August 2005

Week of August 26th, 2005

How Can I Determine the 20 Largest Files on a Computer?  (Fri. – 8/26/05)
How Can I Find All the Users with Remote Access Permissions?  (Thurs. – 8/25/05)
How Can I Determine When the Last Patch From Windows Update was Applied?  (Wed. – 8/24/05)
How Can I Unhide All the Files in a Folder?  (Tues. – 8/23/05)
How Can I Determine Which Attributes are Replicated to the Global Catalog?  (Mon. – 8/22/05)

Week of August 19th, 2005

How Can I Remove All Duplicate Lines From a Text File?  (Fri. – 8/19/05)
How Can I Start Up and Shut Down a Virtual Server Session?  (Thurs. – 8/18/05)
How Can I Enumerate All the Universal Groups in Active Directory?  (Wed. – 8/17/05)
How Can I Monitor the Event Logs for the Occurrence of a Specific Event?  (Tues. – 8/16/05)
How Can I Dynamically Populate a List Box in an HTA?  (Mon. – 8/15/05)

Week of August 12th, 2005

How Can I Change the Icon for an Existing Shortcut?  (Fri. – 8/12/05)
How Can I Determine the Beginning and Ending Date of the Previous Month?  (Thurs. – 8/11/05)
How Can I Tell if the Screen Saver is Active?  (Wed. – 8/10/05)
How Can I Modify a Disk Quota Entry Under Windows 2000?  (Tues. – 8/9/05)
How Can I List All the Songs in the Windows Media Library?  (Mon. – 8/8/05)

Week of August 5th, 2005

How Can I Change the Printer Port for a Printer?  (Fri. – 8/5/05)
How Can I Change File Locations for Microsoft Word?  (Thurs. – 8/4/05)
How Can I Insert a Symbol into a Word Document?  (Wed. – 8/3/05)
How Can I Determine the Uptime for a Server?  (Tues. – 8/2/05)
How Can I Search for Two Items in a Text File?  (Mon. – 8/1/05)

July 2005

Week of July 29th, 2005

How Can I Tell if a Date Falls within a Specified Time Period?  (Fri. – 7/29/05)
How Can I Determine if a WMI Property is Writeable?  (Thurs. – 7/28/05)
How Can I Include Multiple Subroutines in a Single onClick Parameter?  (Wed. – 7/27/05)
How Can I Tile the Windows on the Desktop?  (Tues. – 7/26/05)
How Can I Retrieve a List of the System DSNs on a Computer?  (Mon. – 7/25/05)

Week of July 22nd, 2005

How Can I Determine if the Local Administrator Account has been Renamed on a Computer?  (Fri. – 7/22/05)
How Can I Determine the Current Screen Resolution Being Used on a Computer?  (Thurs. – 7/21/05)
How Can I Determine the Date and Time that a Process Started?  (Wed. – 7/20/05)
How Can I Retrieve Information About the Printer Driver Used by a Printer?  (Tues. – 7/19/05)
How Can I Determine When an Active Directory User Account will Expire?  (Mon. – 7/18/05)

Week of July 15th, 2005

How Can I Share All the Local Printers on a Computer?  (Fri. – 7/15/05)
How Can I Delete an Active Directory Object that Contains Other Objects?  (Thurs. – 7/14/05)
How Can I Change the User Information in Microsoft Office?  (Wed. – 7/13/05)
How Can I Tell Which Version of the .NET Framework is Installed on a Computer?  (Tues. – 7/12/05)
How Can I Monitor Changes to a Registry Key?  (Mon. – 7/11/05)

Week of July 8th, 2005

How Can I Use a Script to Rename a Printer?  (Fri. – 7/8/05)
How Can I Get a List of the ODBC Drivers that are Installed on a Computer?  (Thurs. – 7/7/05)
How Can I Cause a User’s Password to Expire?  (Wed. – 7/6/05)
How Can I Determine When a User Last Changed His or Her Password?  (Tues. – 7/5/05)
Happy Holiday (Mon. – 7/4/05)

Week of July 1st, 2005

How Can I Launch Two Applications, Wait Until One Program Ends, and Then Close the Other?  (Fri. – 7/1/05)
How Can I Add a Line to the Top of a Text File?  (Thurs. – 6/30/05)
How Can I Change the Background Color of a Cell Depending on the Date?  (Wed. – 6/29/05)
How Can I List All the Attributes Used by the Computer Class in Active Directory?  (Tues. – 6/28/05)
How Can I Retrieve a List of OUs that have a Specific Word in Their Name?  (Mon. – 6/27/05)

June 2005

Week of June 24th, 2005

How Can I Get the Actual Text of a List Box or Dropdown List Option?  (Fri. – 6/24/05)
How Can I Determine the Date for the Friday in a Given Week?  (Thurs. – 6/23/05)
How Can I Compare Two String Values Regardless of Letter Case?  (Wed. – 6/22/05)
How Can I Retrieve the Value of an Active Directory Attribute that has a Hyphen in Its Name?  (Tues. – 6/21/05)
How Can I Determine if a File Exists and, if It Does, Exit the Script?  (Mon. – 6/20/05)

Week of June 17th, 2005

How Can I Show Users a Dialog Box That Only Lets Them Select Folders?  (Fri. – 6/17/05)
How Can I Delete Data from a Spreadsheet Yet Keep All the Formatting?  (Thurs. – 6/16/05)
How Can I Determine Which Domain Controller Authenticated a User?  (Wed. – 6/15/05)
How Can I Associate a Network Connection with an IP Address?  (Tues. – 6/14/05)
How Can I Change the Size of the Temporary Internet Files Folder?  (Mon. – 6/13/05)

Week of June 10th, 2005

How Can I Determine the Number of Items Generated by the Split Function?  (Fri. – 6/10/05)
How Can I Clear a Text Box in an HTA?  (Thurs. – 6/9/05)
How Can I Hide a Specific Toolbar in Microsoft Word?  (Wed. – 6/8/05)
How Can I Tally Items in a Text File?  (Tues. – 6/7/05)
How Can I Remove All the Double Quote Marks in a Text File?  (Mon. – 6/6/05)

Week of June 3rd, 2005

How Can I List All the User Profiles on a Computer?  (Fri. – 6/3/05)
How Can I Display More Than 1,023 Characters in a Custom Message Box?  (Thurs. – 6/2/05)
How Can I Retrieve the Path to the %windir% Folder on a Computer?  (Wed. – 6/1/05)
How Can I Open an Excel Workbook and Retrieve the Names of All the Worksheets?  (Tues. – 5/31/05)
Happy Holiday (Mon. - 5/30/2005)

May 2005

Week of May 27th, 2005

How Can I Change the Copy Music to This Location Folder in Windows Media Player?  (Fri. – 5/27/05)
How Can I Get Just the User Name When Using the Win32_ComputerSystem Class?  (Thurs. – 5/26/05)
How Can I Extract Word Paragraphs That Use a Specific Style?  (Wed. – 5/25/05)
How Can I Use ADO to Open a Text File That has Spaces in the File Name?  (Tues. – 5/24/05)
How Can I Correlate Logical Drives and Physical Disks?  (Mon. – 5/23/05)

Week of May 20th, 2005

How Can I Remove the Last Carriage Return-Linefeed in a Text File?  (Fri. – 5/20/05)
How Can I Switch Between Using a Proxy Server and Not Using a Proxy Server?  (Thurs. – 5/19/05)
How Can I Generate Random Numbers Using a Script?  (Wed. – 5/18/05)
How Can I Access Active Directory on a Specific Domain Controller?  (Tues. – 5/17/05)
How Can I Lower the Priority of a Process Using a Script?  (Mon. – 5/16/05)

Week of May 13th, 2005

How Can I Display the Vertical and Horizontal Sizes of a .JPG File?  (Fri. – 5/13/05)
How Can I Get a List of All the Disabled User Accounts in Active Directory?  (Thurs. – 5/12/05)
How Can I Rename a Local Area Connection?  (Wed. – 5/11/05)
How Can I Add an Email Address to the proxyAddresses Attribute?  (Tues. – 5/10/05)
How Can I Create a Shortcut in My Network Places?  (Mon. – 5/9/05)

Week of May 6th, 2005

How Can I Make Internet Explorer Check for a New Version Each Time I Visit a Web Page?  (Fri. – 5/6/05)
How Can I Determine the Week of the Month a Date Falls In?  (Thurs. – 5/5/05)
How Can I Exit a For Each Loop?  (Wed. – 5/4/05)
How Can I Insert Files into a Word Document?  (Tues. – 5/3/05)
How Can I Add a Site to Internet Explorer’s Restricted Sites Zone?  (Mon. – 5/2/05)

April 2005

Week of April 29th, 2005

How Can I Change the User and Computer Account Description Attributes Each Time a User Logs On?  (Fri. – 4/29/05)
How Can I Purge All the Print Jobs on a Windows 2000 Print Server?  (Thurs. – 4/28/05)
How Can I Tell if an Excel Workbook is Open and, If It Isn’t, Open It?  (Wed. – 4/27/05)
How Can I Add All the Users from an Existing Active Directory Group to a New Group?  (Tues. – 4/26/05)
How Can I Configure a Computer to Use a Dynamically-assigned DNS Server?  (Mon. – 4/25/05)

Week of April 22nd, 2005

How Can I Add Two Blank Lines Between Each Line in a Text File?  (Fri. – 4/22/05)
Why Does My Performance Monitoring Script Keep Returning the Same Incorrect Values?  (Thurs. – 4/21/05)
How Can I Pass Command-Line Variables to an HTA When It Starts?  (Wed. – 4/20/05)
How Can I Tell Whether a Group Member is a User, a Computer, or Another Group?  (Tues. – 4/19/05)
How Can I Determine the Version Number of a File?  (Mon. – 4/18/05)

Week of April 15th, 2005

How Can I Search a Text File for 9-Digit Numbers?  (Fri. – 4/15/05)
How Can I Display a Multi-Valued Attribute Returned from an Active Directory Search?  (Thurs. – 4/14/05)
How Can I Eliminate Duplicate Names in a Text File?  (Wed. – 4/13/05)
How Can I Bind to a User Account Using Something Other Than the CN Attribute?  (Tues. – 4/12/05)
How Can I Insert a Column into a Spreadsheet?  (Mon. – 4/11/05)

Week of April 8th, 2005

How Can I Get a List of All the .PST Files on a Computer?  (Fri. – 4/8/05)
How Can I Print a Test Page to a Printer?  (Thurs. – 4/7/05)
How Can I Convert a Comma-Separated Values File to a Tab-Separated Values File?  (Wed. – 4/6/05)
How Can I Delete a Folder and All Its Subfolders?  (Tues. – 4/5/05)
How Can I Monitor for Different Types of Events With Just One Script?  (Mon. – 4/4/05)

Week of April 1st, 2005

How Can I Convert 1,000 .RTF Files to Word Documents?  (Fri. – 4/1/05)
How Can I Determine the Size of the My Documents Folder?  (Thurs. – 3/31/05)
How Can I Copy and Rename a Worksheet in the Same Workbook?  (Wed. – 3/30/05)
How Can I Clear a List Box in an HTA?  (Tues. – 3/29/05)
How Can I Add a Word to a Text File if That Word Isn’t Already in the File?  (Mon. – 3/28/05)

March 2005

Week of March 25th, 2005

How Can I Write Double Quotes to a Text File?  (Fri. – 3/25/05)
Thursday, March 24, 2005 – No column (TechNet maintenance)
How Can I Set an Active Directory Attribute Value to NULL?  (Wed. – 3/23/05)
How Can I Save a Single Excel Worksheet to a CSV File?  (Tues. – 3/22/05)
How Can I Be Notified Any Time a Network Cable Gets Unplugged?  (Mon. – 3/21/05)

Week of March 18th, 2005

How Can I Create an Environment Variable Using a Script?  (Fri. – 3/18/05)
How Can I Move Files Based on Their File Extension?  (Thurs. – 3/17/05)
How Can I Display A Progress Bar (or Something Similar) While My Script Runs?  (Wed. – 3/16/05)
How Can I Determine Which USB Devices are Connected to a Computer?  (Tues. – 3/15/05)
How Can I Automatically Dismiss a Message Box After a Specified Length of Time?  (Mon. – 3/14/05)

Week of March 11th, 2005

How Can I Delete a Table from a Jet Database?  (Fri. – 3/11/05)
How Can I Temporarily Add a Group to Another Active Directory Group?  (Thurs. – 3/10/05)
How Can I Determine Which Version of Internet Explorer is Installed on a Computer?  (Wed. – 3/9/05)
How Can I Get a List of All the Domains in a Forest?  (Tues. – 3/8/05)
How Can I Tell If a File Exists on a CD or DVD Drive?  (Mon. – 3/7/05)

Week of March 4th, 2005

How Can I Delete a Single Registry Value?  (Fri. – 3/4/05)
How Can I Determine the Elapsed Time Between Two Dates?  (Thurs. – 3/3/05)
How Can I Create a Folder on the Start Menu?  (Wed. – 3/2/05)
How Can I Use a Multi-Select Dialog Box in a Script?  (Tues. – 3/1/05)
How Can I Determine if a Folder Exists on a Computer?  (Mon. – 2/28/05)

February 2005

Week of February 25th, 2005

How Can I Sort the Contents of a Text File?  (Fri. – 2/25/05)
How Can I Write Binary Data to the Registry?  (Thurs. – 2/24/05)
How Can I Read Text From a File and Then Rename the File Using the Text I Just Read?  (Wed. – 2/23/05)
How Can I Tell Whether a Web Page is Accessible?  (Tues. – 2/22/05)
How Can I Create a GUID Using a Script?  (Mon. – 2/21/05)

Week of February 18th, 2005

How Can I List the Files in a Folder and All Its Subfolders?  (Fri. – 2/18/05)
How Can I Count the Number of Times a User has Logged on to a Computer?  (Thurs. – 2/17/05)
How Can I List Open Sessions and Open Files on a Computer?  (Wed. – 2/16/05)
How Can I Add a Hyperlink to a Word Document?  (Tues. – 2/15/05)
How Can I Add a Web Site to the Trusted Sites Zone?  (Mon. – 2/14/05)

Week of February 11th, 2005

How Can I Use a Wildcard Character to Delete Folders?  (Fri. – 2/11/05)
How Can I Disable the Guest Account on a Computer?  (Thurs. – 2/10/05)
How Can I Change the Target of a Desktop Shortcut?  (Wed. – 2/9/05)
How Can I Find and Replace Text in a Text File?  (Tues. – 2/8/05)
How Can I Password-Protect an Excel Spreadsheet?  (Mon. – 2/7/05)

Week of February 4th, 2005

How Can I Mask Passwords Using an InputBox?  (Fri. – 2/4/05)
How Can I Determine Whether or Not a Group Has Any Members?  (Thurs. – 2/3/05)
How Can I Get a List of All My Windows Server 2003 Computers?  (Wed. – 2/2/05)
How Can I Change the Working Folder of a Script?  (Tues. – 2/1/05)
How Can I Make Changes to and Then Re-Save an Existing Excel Spreadsheet?  (Mon. - 1/31/05)

January 2005

Week of January 28th, 2005

How Can I Show Users a Dialog Box for Selecting Files?  (Fri. - 1/28/05)
How Can I Determine the System Time on a Computer?  (Thurs. - 1/27/05)
How Can I Retrieve Information From My Event Logs Regarding Unsuccessful Logons?  (Wed. - 1/26/05)
How Can I Read Just a Single, Specified Line from a Text File?  (Tues. - 1/25/05)
How Can I Determine the Next Available Drive Letter on a Computer?  (Mon. - 1/24/05)

Week of January 21st, 2005

How Can I Find and Move an Active Directory Computer Account?  (Fri. - 1/21/05)
How Can I Tell Which Switches Were Used When Starting an Executable File?  (Thurs. - 1/20/05)
How Can I Change the Caption for the My Computer Icon?  (Wed. - 1/19/05)
How Can I Make a Read-Only File Writeable?  (Tues. - 1/18/05)
How Can I Change the Legal Warning Message Using a Script?  (Mon. - 1/17/05)

Week of January 14th, 2005

How Can I Tell if a Folder Has Any Files with a Specific File Extension?  (Fri. - 1/14/05)
How Can I Map a Printer, But Only If the User Doesn’t Have a Local Printer?  (Thurs. - 1/13/05)
How Can I Access a Type Library From within a Script?  (Wed. - 1/12/05)
How Can I Put the User Name into the Footer of a Microsoft Word Document?  (Tues. - 1/11/05)
How Can I Determine Which Version of Word is Installed on a Computer?  (Mon. - 1/10/05)

Week of January 7th, 2005

How Can I Share a Folder on a Remote Computer?  (Fri.- 1/7/05)
How Can I Tell On What Date an Active Directory User Account Was Created?  (Thurs.- 1/6/05)
How Can I Prompt a User to Delete (or Not Delete) a Computer Account?  (Wed.- 1/5/05)
How Can I Return Only the Last Record Written to an Event Log?  (Tues.- 1/4/05)
How Can I Determine the Account a Process is Running Under?  (Mon.- 1/3/05)

December 2004

Week of December 31st, 2004

Happy Holiday  (12/27/04 – 12/31/04)

Week of December 24th, 2004

Happy Holiday  (Fri.- 12/24/04)
Happy Holiday  (Thurs.- 12/23/04)
How Can I Save Word Documents as Text Files By Using a Script?  (Wed.- 12/22/04)
How Can I Tell Whether a Group is a Security Group or a Distribution Group?  (Tues.- 12/21/04)
How Can I Return a List of Downloaded Controls and Applets for Internet Explorer?  (Mon.- 12/20/04)

Week of December 17th, 2004

How Can I Connect to a Folder When There’s an Apostrophe in the Folder Name?  (Fri.- 12/17/04)
How Can I Get a List of All the Domain Controllers in My Domain?  (Thurs.- 12/16/04)
How Can I Grab a URL From the Clipboard and Then Open That Web Site in a Browser?  (Wed.- 12/15/04)
How Can I Rename an Active Directory Group?  (Tues.- 12/14/04)
How Can I Run a Script Under Alternate Credentials?  (Mon.- 12/13/04)

Week of December 10th, 2004

How Can I Map Drives Based on Membership in a Group?  (Fri.- 12/10/04)
How Can I Rename Files Based on the File’s Creation Date?  (Thurs.- 12/9/04)
How Can I Determine the Executable File Corresponding to a Shortcut?  (Wed.- 12/8/04)
How Can I Return a List of All My Computers Except Those in a Specified OU?  (Tues.- 12/7/04)
How Can I Assign a New UPN to All My Users?  (Mon.- 12/6/04)

November 2004

Week of December 3rd, 2004

How Can I Determine the SID for a User Account?  (Fri.- 12/3/04)
How Can I Prevent a Local User From Changing His or Her Password?  (Thurs.- 12/2/04)
Can I Combine Multiple Text Files Using a Script?  (Wed.- 12/1/04)
Can I Edit .INI Files Using a Script?  (Tues.- 11/30/04)
How Can I Attach a File to an Email Sent Using CDO?  (Mon.- 11/29/04)

Week of November 26th, 2004

Happy Holiday (Fri.- 11/26/04)
Happy Holiday  (Thurs.- 11/25/04)
How Can I Retrieve Disk Quota Information for a Single User?  (Wed.- 11/24/04)
How Can I Run a Script Against a Range of IP Addresses?  (Tues.- 11/23/04)
How Can I List the Members of a Group in Alphabetical Order?  (Mon.- 11/22/04)

Week of November 19th, 2004

How Can I Put New Users in the Same OU as the Person Creating Their Accounts?  (Fri.- 11/19/04)
Can I Use a Script to Determine the Size of a Folder on a Remote Computer?  (Thurs.- 11/18/04)
Is There Any Way to Determine the Default Printer On a Computer?  (Wed.- 11/17/04)
Can I Read an Entire Text File Rather Than Reading It Line-by-Line?  (Tues.- 11/16/04)
Can I Lock a Workstation Using a Script?  (Mon.- 11/15/04)

Week of November 12th, 2004

How Can I Tell If an OU Has Any User Accounts In It?  (Fri.- 11/12/04)
Can I Pin a File to the Start Menu by Using a Script?  (Thurs.- 11/11/04)
Can I Create and Delete a DSN Using a Script?  (Wed.- 11/10/04)
Can I Use a Script to Rename All the Files in a Folder?  (Tues.- 11/9/04)
How Can I Change the Internet Explorer Home Page?  (Mon.- 11/8/04)

Week of November 5th, 2004

How Can I Work with a CN that Has a Comma in It?  (Fri.- 11/5/04)
How Can I Delete All Files Older Than a Specified Date?  (Thurs.- 11/4/04)
How Can I Play a Sound From Within a Script?  (Wed.- 11/3/04)
How Can I Delete the Files in the Temporary Internet Files Folder?  (Tues.- 11/2/04)
How Can I Make Selections from a Form When Using a Script?  (Mon.- 11/1/04)

October 2004

Week of October 29th, 2004

How Can I Tell Whether a Value Exists in the Registry?  (Fri.- 10/29/04)
How Can I Create a CSV File?  (Thurs.- 10/28/04)
How Can I Change the Screensaver Timeout Value?  (Wed.- 10/27/04)
Can I Retrieve Just Failure Events from the Security Event Log?  (Tues.- 10/26/04)
How Can I Send Data from One Script to Another?  (Mon.- 10/25/04)

Week of October 22nd, 2004

How Can I Display a Hyperlink in a Message Box?  (Fri.- 10/22/04)
How Can I Determine the OU a User Account Belongs To?  (Thurs.- 10/21/04)
How Can I Get a List of All the Files in a Folder and Its Subfolders?  (Wed.- 10/20/04)
How Can I Change a Read-only File to a Read-write File?  (Tues.- 10/19/04)
How Can I Pick Out and Save Specific Lines in a Text File?  (Mon.- 10/18/04)

Week of October 15th, 2004

How Can I Change a User’s Password?  (Fri.- 10/15/04)
How Can I Determine if My Users Have Certain Files on Their Computers?  (Thurs.- 10/14/04)
How Can I Determine the Percentage of Free Space on a Drive?  (Wed.- 10/13/04)
How Can I Count the Number of Lines in a Text File?  (Tues.- 10/12/04)
How Can I Automatically Run a Script Any Time a File is Added to a Folder?  (Mon.- 10/11/04)

Week of October 8th, 2004

How Can I Add a Domain User to a Local Administrators Group?  (Fri.- 10/08/04)
How Can I Determine the Owner of a File?  (Thurs.- 10/07/04)
How Can I Tell Which Scripts are Running on a Computer?  (Wed.- 10/06/04)
How Can I Pause a Script and Then Resume It When a User Presses a Key on the Keyboard?  (Tues.- 10/05/04)
How Can I Print Text Files Using a Script?  (Mon.- 10/04/04)

September 2004

Week of October 1st, 2004

How Can I Write to the Comments Field of a Document?  (Fri.- 10/01/04)
How Can I Compare the Memberships of Two Groups?  (Thurs.- 09/30/04)
How Can I Tell Which Service Packs Have Been Installed on a Computer?  (Wed.- 09/29/04)
How Can I Get a List of the Devices That Aren't Working?  (Tues.- 09/28/04)
How Can I Terminate a Process with a Specific PID?  (Mon.- 09/27/04)

Week of September 24th, 2004

How Can I Get a List of Exchange Servers Assigned to My Users?  (Fri.- 09/24/04)
How Can I Display Multiple Lines of Output in a Web Page?  (Thurs.- 09/23/04)
Is There an Easy Way to Manage Scheduled Tasks Using Scripts?  (Wed.- 09/22/04)
How Can I Determine if a Computer is a Laptop or a Desktop Machine?  (Tues.- 09/21/04)
How Can I Tell if a Computer has a DVD Drive Installed?  (Mon.- 09/20/04)

Week of September 17th, 2004

How Can I Bind to a User Account in a Sub-OU?  (Fri.- 09/17/04)
How Can I Get Rid of Extraneous Spaces in a String?  (Thurs.- 09/16/04)
How Can I Use Both Command-line Arguments and a Default Value?  (Wed.- 09/15/04)
Why Doesn't My Ping Script Run on Windows 2000 Computers?  (Tues.- 09/014/04)
Why Doesn't My LIKE Query Work on Windows 2000?  (Mon.- 09/13/04)

Week of September 10th, 2004

How Can I Tell Which Account a Service is Running Under?  (Fri.- 09/10/04)
How Can I Read in IP Addresses and Use Them in a Script?  (Thurs.- 09/09/04)
How Can I Determine the Version Number of an Executable File?  (Wed.- 09/08/04)
How Can I Tell if a Server has Rebooted?  (Tues.- 09/07/04)
Happy Holiday  (Mon.- 09/06/04)

Week of September 3rd, 2004

How Can I Be Notified Any Time a Service Goes Down?  (Fri.- 09/03/04)
How Can I Enumerate All the Objects in an Active Directory OU?  (Thurs.- 09/02/04)
How Can I Create a Folder on a Remote Computer?  (Wed.- 09/01/04)
How Can I Prompt a User for Input?  (Tues.- 08/31/04)
How Can I Stop a Script Partway Through?  (Mon.- 08/30/04)


August 2004

Week of August 27th, 2004

How Can I Determine the Day of the Week?   (Fri. - 08/27/04)
Can I Change the Command Window Title When Running a Script?   (Thurs. – 08/26/04)
Why am I Getting an Error when Trying to Determine an IP Address?   (Wed. – 08/25/04)
How Come My Search Doesn’t Return All My User Accounts?   (Tues. – 08/24/04)
Can I Change the Current Directory When Running a Script?   (Mon. – 08/23/04)

Week of August 20th, 2004

How Can I Determine Which Groups a User Belongs To?   (Fri. – 08/20/04)
How Can I Determine if a Folder Exists on a Computer?   (Thurs. – 08/19/04)
How Can I Determine How Long It Takes a Script to Run?   (Wed. – 08/18/04)
How Can I Save Output to a Text File?   (Tues. – 08/17/04)
How Can I Give a User a Yes/No Prompt?   (Mon. – 08/16/04)

Week of August 13th, 2004

Can I Copy Script Output to the Clipboard?   (Fri. – 08/13/04)
Can I Read a Text File From the Bottom Up?   (Thurs. – 08/12/04)
Can I Get a List of All My User Accounts?   (Wed. – 08/11/04)
How Can I Call the Dir Command?   (Tues. – 08/10/04)
Can I Enable the Caps Lock Key?   (Mon. – 08/09/04)

Week of August 6th, 2004

How Can I Use Long File Names as Parameters?   (Fri. – 08/06/04)
How Can I Determine if a User is a Local Administrator?   (Thurs. – 08/05/04)
Can I Change a Message Box Caption?   (Wed. – 08/04/04)
How Can I Get Yesterday’s Date?   (Tues. – 08/03/04)
How Come My Registry Script Doesn't Work?   (Mon. – 08/02/04)


Top of pageTop of page