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. We can’t guarantee we’ll be able to answer every question that comes our way, but we’ll do our best.

 

July 2008

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 G