The Curious Engineer

Scripting Blog [archived]

2004–2007

834 posts

2008–2012 →

2007 244

December 2007

  1. Hey, Scripting Guy! How Can I Determine If Any of the Files in a Folder Have Been Modified in the Past 90 Days?
  2. Hey, Scripting Guy! How Can I Remove Duplicate Values From a Pair of Text Files?
  3. Hey, Scripting Guy! How Can I Change the Background Color of a Text Box?
  4. Hey, Scripting Guy! How Can I Delete Files That Are a Specified Number of Hours Old?
  5. Hey, Scripting Guy! How Can I Replace Text That Includes Double Quote Marks and a Tab Character?
  6. Hey, Scripting Guy! How Can I Map Drives Based on Membership in an Active Directory Group When the User Belongs to Multiple Groups?
  7. Hey, Scripting Guy! How Can I Map Drives Based on Membership in an Active Directory Group?
  8. How Can I Start a Script in a Hidden Window?
  9. Hey, Scripting Guy! How Can I Cut a Row From One Office Excel Spreadsheet and Paste That Row Into Another Spreadsheet?
  10. Hey, Scripting Guy! How Can I Start an Application From a Windows PowerShell Script, Then Pause the Script Until the Application Has Terminated?
  11. Hey, Scripting Guy! How Can I Change the Font Size of a Span in an HTA?

November 2007

  1. Hey, Scripting Guy! How Can I Remove Everything From an Active Directory Group Except Other Groups?
  2. Hey, Scripting Guy! How Can I Determine the Manager for All the Groups in Active Directory?
  3. Hey, Scripting Guy! How Can I Retrieve Time Zone Information for a Computer?
  4. Hey, Scripting Guy! How Can I Randomly Assign a Picture From the My Pictures Folder as the Computer Wallpaper?
  5. Hey, Scripting Guy! How Can I Tell If a Time Occurred in the Morning or the Evening?
  6. How Can I Limit the Number of Characters That Can Be Typed Into a Textarea?
  7. Hey, Scripting Guy! How Can I Tell If a Computer Has a SmartCard Reader Attached?
  8. Hey, Scripting Guy! How Can I Set the Date and Time on a Computer?
  9. Hey, Scripting Guy! How Can I Create a Self-Updating Text Box in an HTA?
  10. Hey, Scripting Guy! How Can I Run a Script Any Time Office Outlook is Started?
  11. Hey, Scripting Guy! How Can I Remove Old Files From All the Folders That Share a Folder Name?
  12. Hey, Scripting Guy! How Can I Extract a User Name and Drive Name From a String Value?
  13. Hey, Scripting Guy! How Can I Save Information in an HTA as a Tab-Separated Values File?
  14. Hey, Scripting Guy! How Can I Get the Name and whenCreated Values for All the Users in Active Directory?
  15. Hey, Scripting Guy! How Can I Remove a Value From the Path Environment Variable?
  16. Hey, Scripting Guy! How Can I Create a Bunch of .WAV Files in a Folder?
  17. Hey, Scripting Guy! How Can I Make the Name of the File the First Line of Each Text File in a Folder?
  18. Hey, Scripting Guy! How Can I Remove All the Network Printers on a Computer?
  19. Hey, Scripting Guy! How Can I Determine the Value of the Last Cell in an Office Excel Range?
  20. Hey, Scripting Guy! How Can I Use Windows PowerShell to Delete All the Files in a Folder Older Than 90 Days?

October 2007

  1. Hey, Scripting Guy! How Can I Determine the Age, in Years, of an Office Outlook Contact?
  2. Hey, Scripting Guy! How Can I Start a Remote Process Under CScript If the Script Path Contains Blank Spaces?
  3. Hey, Scripting Guy! How Can I Present a Dialog Box that Allows Users to Rename Files?
  4. Hey, Scripting Guy! How Can I Be Notified if an Access Database File Exceeds a Specific Size?
  5. Hey, Scripting Guy! How Can I Move Files Based on a Value in the File Name?
  6. Hey, Scripting Guy! How Can I Extract All the Text Between Two Tags in a Text File?
  7. Hey, Scripting Guy! How Can I Convert a Number to a Date and Then Back in Excel?
  8. Hey, Scripting Guy! How Can I Retrieve a List of Unique Users from the Security Event Log?
  9. Hey, Scripting Guy! How Can I Tell if a Computer is Bluetooth-Enabled?
  10. Hey, Scripting Guy! How Can I Insert New Rows Above the Last Row in an Office Excel Spreadsheet?
  11. Hey, Scripting Guy! How Can I Copy Data from Excel to PowerPoint?
  12. How Can I Determine the Percentage of Free Space on a Drive?
  13. Hey, Scripting Guy! How Can I Map Drives Based on IP Address?
  14. Hey, Scripting Guy! How Can I Retrieve Hyperlink Information From an Office Excel Spreadsheet?
  15. Hey, Scripting Guy! How Can I Search Multiple OUs in Active Directory?
  16. Hey, Scripting Guy! How Can I Insert Blank Rows (and Formulas) Into an Office Excel Worksheet?
  17. Hey, Scripting Guy! How Can I Remove Unwanted Tabs From a Text File?
  18. Hey, Scripting Guy! How Can I Save the Attachments for All My New Office Outlook Messages?
  19. Hey, Scripting Guy! How Can I Convert an Extension Number to an Actual Phone Number?
  20. Hey, Scripting Guy! How Can I Retrieve the Field Size and a Sample Record For All the Tables and Fields in an Office Access Database?
  21. Hey, Scripting Guy! How Can I Automatically Move the Focus as Users Type in an HTA?
  22. Hey, Scripting Guy! How Can I Search a Text File for Terms Read In From a Second Text File?

September 2007

  1. How Can I Retrieve Field Values in a Microsoft Word Document?
  2. How Can I Retrieve IP Addresses (and Only IP Addresses) From a Text File?
  3. How Can I Create a New Folder in Microsoft Outlook?
  4. How Can I Allow Users to Type Text Into an HTA Table?
  5. How Can I Change the Paragraph Case in Microsoft Word?
  6. How Can I Apply a New Template to a PowerPoint Presentation?
  7. How Can I Dynamically Show Available Drive Letters in a List Box?
  8. How Can I Count the Number of Users in a Group?
  9. How Can I Move Files Off a User’s Desktop and Into Specified Folders?
  10. How Can I Parse a Comma-Separated Values File?
  11. How Can I Extract Text Embedded Between Target Phrases in a Text File?
  12. How Can I Determine Which Version of Windows Vista is Installed on a Computer?
  13. How Can I Update and Then Break All the Links in an Excel Spreadsheet?
  14. How Can I Open All the Excel Spreadsheets in a Folder and Run a Specified Macro Found in Each of Those Spreadsheets?
  15. How Can I Assign Multiple Home Pages to Internet Explorer 7.0?
  16. How Can I Remove Any Line in a Text File That Contains a Specified String Value?
  17. How Can I Backup an Event Log to a Text File?
  18. How Can I List the Addresses in My Sent Items Folder in an Excel Spreadsheet?
  19. How Can I Add a Background Picture to an Excel Worksheet?
  20. How Can I Remove All the Non-Alphabetic Characters in a String?

August 2007

  1. How Can I Execute a Scheduled Task in Windows Vista?
  2. How Can I Reverse All the Lines in a Text File?
  3. How Can I Get a List of Appointments for a Specific Month?
  4. How Can I Find All the Files in a Directory Tree that Contain a Specific Word or Phrase?
  5. How Can I Replace Numeric Values in an Excel Spreadsheet?
  6. How Can I Delete the Oldest File From a Folder If and When That Folder Exceeds a Specified Size?
  7. How Can I Get the GUID for a User Account If All I Have is the User’s Logon Name and Domain?
  8. How Can I Copy Data From One Spreadsheet to Another?
  9. How Can I Tell If a Wireless Network Adapter is Connected to the Network?
  10. How Can I Report Disk Quota Information For the Logged-on User?
  11. How Can I Copy the Folder Structure of a Folder?
  12. How Can I Replace Text in an Excel Spreadsheet?
  13. How Can I Combine Lines in a Text File?
  14. How Can I Insert a Manual Line Break into a Microsoft Word Document?
  15. How Can I Determine If the Number of Files in a Series of Folders Exceeds a Specified Value?
  16. How Can I Save Emails That Are More Than One Month Old?
  17. How Can I Copy Two Files to Each of the Shared Folders on a Computer?
  18. How Can I Search For and Modify Formatted Text in a Word Document?
  19. How Can I Create a Sequential Series of Folders?
  20. How Can I Add the Date a Picture Was Taken to the File Names of My Digital Photos?
  21. How Can I Get a List of User Accounts Created On Or Between Two Dates?
  22. How Can I Play a Sound Each Time a Message Box is Displayed?
  23. How Can I Create a New Outlook Distribution List Based On the Membership of an Active Directory Group?

July 2007

  1. How Can I Dynamically Link Two Drop-Down Lists?
  2. How Can I Map a Printer Based on the Computer’s OU?
  3. How Can I Configure PowerPoint to Print Handouts Instead of Slides?
  4. How Can I Create a New WMI Namespace Under the Root Namespace?
  5. How Can I Save All My Contacts as VCards?
  6. How Can I Check Every 30 Minutes to See If a File Has Been Modified?
  7. How Can I Delete Specified Characters From the Beginning and End of My File Names?
  8. How Can I Create a Custom Dialog Box?
  9. How Can I Add an HTML Tag to the End of Each Line in a File?
  10. How Can I Display a Default Message If Nothing Has Been Typed Into a Text Box?
  11. How Can I List the Network Printers For the Logged-On User?
  12. How Can I Create a File of a Specified Size?
  13. How Can I Use Windows PowerShell to Retrieve Environment Variables and Special Folder Paths?
  14. How Can I Ensure That a User Enters Only Allowed Characters in a Text Box?
  15. How Can I Insert a Page Break in a Text File After Each Line Where the Only Character is the Number 1?
  16. How Can I List All the Fields and Data Types in an Access Database?
  17. How Can I Set the Print Area in an Excel Spreadsheet?
  18. How Can I Replace Null Values in an Array?
  19. How Can I Change the Local Administrator Password on All My Computers?
  20. How Can I Create a Folder With a Name Based on the Monday and Friday of the Coming Week?

June 2007

  1. How Can I Delete Unread Emails That Are More Than 6 Months Old?
  2. How Can I Prompt for a Computer Name and Then Delete That Computer Account From Active Directory?
  3. How Can I Remap Network Drives So They Use an IP Address Rather Than a Computer Name?
  4. How Can I Search For Red Text in a Microsoft Word Document?
  5. How Can I Create a Folder for Each User in My Domain?
  6. How Can I Delete Specified Rows in an Excel Spreadsheet?
  7. How Can I Open a Window to a UNC Location?
  8. How Can I Color Every Other Row in an Excel Spreadsheet?
  9. How Can I Insert Commas at Specified Locations in Each Line in a Text File?
  10. How Can I Remove a Specific Set of Users From the Local Administrators Group?
  11. How Can I Randomly Select an Email From an Outlook Mail Folder?
  12. How Can I Change the Default File Save Format in Microsoft Word?
  13. How Can I Rename a File Every Day, Using the Current Date as Part of the File Name?
  14. How Can I Put the File Name in the Footer of a Microsoft Word Document?
  15. How Can I Clear the Contents of a Text File?
  16. How Can I Get a List of All the PDF Files in a Folder and Its Subfolders?
  17. How Can I Create a Shortcut For an Executable File That Uses Parameters?
  18. How Can I Add a Page X of Y Footer to a Microsoft Word Document?
  19. How Can I Append a Value to a Specified Field For Each Record in a Database?
  20. How Can I Copy Selected Columns From a CSV File to an Excel File?
  21. How Can I Change the File Extension for All the Files in a Folder?

May 2007

  1. How Can I Wait Until One Application Has Quit Before Starting a Second Application?
  2. How Can I Delete the First Line and the Last Line in a Text File?
  3. How Can I Change the Background Color of Spreadsheet Rows That Have a Date in a Specified Cell?
  4. How Can I Export an HTA Table to Excel?
  5. How Can I Compare the Contents of Two Text Files?
  6. How Can I Save Each Paragraph in a Word Document as a Database Record?
  7. How Can I Monitor the Number of Files in a Folder?
  8. How Can I Add the Contents of a Group of Text Files to an Access Database?
  9. How Can I Search Every Text File in a Folder For Phone Numbers?
  10. How Can I Search For Phone Numbers in a Text File?
  11. How Can I Force All the Users in an OU to Change Their Password the Next Time They Log On?
  12. How Can I Copy the Same File to a Number of Different Computers?
  13. How Can I Dynamically Hide and Show a Control in an HTA?
  14. How Can I Highlight a Keyword in an HTA?
  15. How Can I Determine the Topmost OU For an Active Directory Object?
  16. How Can I Prevent Users From Typing Anything But Numbers Into an HTA Text Box?
  17. How Can I List All the Meetings Scheduled By a Specified Person?
  18. Hey, Scripting Guy! How Can I Delete All the Duplicates in a Set of Processes But Keep the Oldest Process?
  19. How Can I Replace Single Quote Marks in a Text File?
  20. Hey, Scripting Guy! How Can I Determine the Home Directory For All the Disabled User Accounts in Active Directory?
  21. How Can I Ensure That a Script Runs Only Once on a Computer?
  22. How Can I Delete All the Worksheets in a Spreadsheet Except for the First Worksheet?

April 2007

  1. How Can I Remove the First Five Lines From All the Log Files in a Folder?
  2. How Can I Assign a Background Color to Cells in a Spreadsheet and Then “Sum” Those Cells?
  3. How Can I Start a Process and Then Log the User Off When That Process Ends?
  4. How Can I Sort a Row in an Excel Spreadsheet?
  5. How Can I Get the Command Window to Stay Open When I Right-Click a Script and Choose Open With Command Prompt?
  6. How Can I Replace the First Five Characters in a Text File With the First Five Characters in the Computer Name?
  7. How Can I Write a Script That Increments a Counter Each Time a Log File is Updated?
  8. How Can I Get a List of All the Local Users Who Have an Expiring Password?
  9. How Can I Tell Which Version of QuickTime is Installed on a Computer?
  10. How Can I Tack a Prefix Onto the Telephone Numbers of All the Users in My Domain?
  11. How Can I Read the Contents of a Text File and Then Declare the Contents as Variables?
  12. How Can I Map Drive X on a Computer, But Only If Drive X isn’t Already in Use?
  13. How Can I Remove the Password When Opening an Excel Spreadsheet?
  14. How Can I Get a List of All the Users Who Have a Process Open on a Computer?
  15. How Can I Filter Outlook Messages By Email Address?
  16. How Can I Tell Whether a Laptop Computer is Running Off Batteries?
  17. How Can I Let Users Choose a Default Printer From a List of Printers?
  18. How Can I Configure an Expiration Date for a Local User Account?
  19. How Can I Import an Excel Spreadsheet Into an Access Database?
  20. How Can I Save a Table in an Access Database as a Spreadsheet?
  21. Hey, Scripting Guy! How Can I Determine the Grace Period for a Computer Running Windows Vista?

March 2007

  1. How Can I Locate a Word in a Text File and Then Echo Back That Word and Any Remaining Text?
  2. How Can I Search a Text File for Strings Meeting a Specified Pattern?
  3. How Can I Change the Color of the Scrollbars in an HTA?
  4. How Can I List All the Members of a Microsoft Outlook Distribution List?
  5. How Can I Use Windows PowerShell to Be Notified When an Application Terminates?
  6. How Can I Parse a Tab-Delimited File and Then Save That as a Comma-Separated Values File?
  7. How Can I Determine the Signal Strength of a Wireless Connection?
  8. How Can Users Type Data Into an HTA Without Using Text Boxes?
  9. How Can I Map a Drive Based on a User’s Name and OU?
  10. How Can I Delete a Desktop Shortcut If I Don’t Know the Shortcut’s File Path?
  11. How Can I Force a Specified Letter Case in an HTA?
  12. How Can I Format a Series of Numbers as a Phone Number?
  13. How Can I Replace a Specified Font in a Microsoft Word Document?
  14. How Can I Use Graphics in an HTA’s Bulleted List?
  15. How Can I Determine the Follow-Up Status of Outlook Emails?
  16. How Can I Change a Service Description?
  17. How Can I Verify the System Time on a Remote Computer?
  18. How Can I Tell If Any of My Contacts Have a Birthday This Month?
  19. How Can I Apply a Theme to a Microsoft Word Document?
  20. How Can I Count the Number of Characters in a Text File?
  21. How Can I Modify a Text File and Then Extract Selected Lines From the Modified Contents?
  22. How Can I Change the First Two Octets of an IP Address?
  23. How Can I Get the Uptime of a Service?

February 2007

  1. How Can I Tally Up All the Words Found in a Text File?
  2. How Can I Monitor Event Log Messages for Specific Words?
  3. How Can I Add the Last-Saved Date to the Footer of a Microsoft Word Document?
  4. How Can I Tell If a Script is Running on the First or Second Monday of a Month?
  5. How Can I Return Information For Each Member in a Group?
  6. How Can I Use a Blank Row to Separate Data in an Excel Spreadsheet?
  7. How Can I Specify the Number of Decimal Places to Display in an Excel Spreadsheet?
  8. How Can I Insert Text Into a “Bookmark” in a Text File?
  9. How Can I Get the Full Name of a Windows NT 4.0 User When All I Have is Their Logon Name?
  10. How Can I Automatically Open New Files Added to a Folder?
  11. How Can I Change the Last Modified Timestamp for All the Files in a Folder?
  12. Hey, Scripting Guy! How Can I Configure Office Excel to Autosave Every 5 Minutes?
  13. Hey, Scripting Guy! How Can I Log a User Off After 5 Minutes of Inactivity?
  14. Hey, Scripting Guy! How Can I Save an Office Excel Chart as a Picture?
  15. Hey, Scripting Guy! How Can I Prompt a User for Information and Then Pass That Information to a Command-Line Tool?
  16. Hey, Scripting Guy! How Can I Import a .CSV File into an Office Access Database?
  17. Hey, Scripting Guy! How Can I Specify the Tab Order in an HTA?
  18. Hey, Scripting Guy! How Can I Use Windows PowerShell to Get a List of All the Open Windows on a Computer?
  19. Hey, Scripting Guy! How Can I Delete All the Messages in My Sent Items Folder?
  20. Hey, Scripting Guy! How Can I Change the Font Color in Office Excel If a Specified Condition is Met?

January 2007

  1. Hey, Scripting Guy! How Can I Determine the Default Buffer Size for the Command Window?
  2. Hey, Scripting Guy! How Can I Delete All the .CSG Files on Drive C of a Computer?
  3. Hey, Scripting Guy! How Can I Get a List of All the Subfolders in a Folder and Then Put That List Into an Array?
  4. Hey, Scripting Guy! How Can I Convert an Office Excel Spreadsheet to XML?
  5. Hey, Scripting Guy! How Can I Start Office Outlook If It Isn’t Already Running?
  6. Hey, Scripting Guy! How Can I Get the Name of the Last User to Log on to a Computer?
  7. Hey, Scripting Guy! How Can I Create A New Folder Using a Name Based on the Current Date?
  8. Hey, Scripting Guy! How Can I Insert a Date Field in Office Word?
  9. Hey, Scripting Guy! How Can I Change the Desktop Wallpaper to One of Six Predefined Selections?
  10. How Can I Delete Just the IP Addresses From Each Line in a Text File?
  11. Hey, Scripting Guy! How Can I Set the Default File Path in Office Excel to a User’s Home Directory?
  12. Hey, Scripting Guy! How Can I List All the Groups in a Windows NT 4.0 Domain?
  13. Hey, Scripting Guy! How Can I Subtract Days From a UTC Date-Time Value in Windows 2000?
  14. Hey, Scripting Guy! How Can I Take Action Based on the First Line of a Text File?
  15. Hey, Scripting Guy! How Can I Retrieve the Subject Property for a .MSI File?
  16. Hey, Scripting Guy! How Can I Add a New Item to the Microsoft Office Word AutoCorrect List?
  17. Hey, Scripting Guy! How Can I Determine the Version of DirectX Installed on a Computer?
  18. Hey, Scripting Guy! How Can I Get the “Date Picture Taken” Property From a .JPG File?
  19. How Can I Number the Lines in a Text File?
  20. How Can I Clear All the Formatting From a Microsoft Word Document?
  21. How Can I Append a Blank Line to a Text File, Then Append the Current Date and Time?

2006 244

December 2006

  1. How Can I List All the Access Database Files on a Computer?
  2. How Can I Set a User’s Password and Then Require Them to Change That Password the Next Time They Log on?
  3. How Can I Create a Shortcut That Opens Internet Explorer With the Address Bar Hidden?
  4. How Can I Add a Network Printer at Logon and, Optionally, Make That the Default Printer?
  5. How Can I Copy My Users’ Phone Number Attribute to Their Description Attribute?
  6. How Can I Start a Process and Then Wait For the Process to End Before Terminating the Script?
  7. How Can I Compare a List of Names in One Excel Column to a List of Names in Another Column?
  8. How Can I Determine the OU the Local Computer Belongs To?
  9. How Can I Convert a Tilde-Delimited File to Microsoft Excel Format?
  10. How Can I Expand the Width of the Windows PowerShell Console?
  11. How Can I Search Active Directory for User Names Stored in an Excel Spreadsheet?

November 2006

  1. How Can I Read the Individual Lines in a Multi-Line Text Box in a HTA?
  2. How Can I Change the Text for the Marquee Screen Saver?
  3. How Can I Rename a Folder?
  4. How Can I Position the Cursor in a Specific Text Box Each Time I Start an HTA?
  5. How Can I Locate a Value in a Text File and Then Parse the Line of Text Where the Value Was Found?
  6. How Can I Add a Function to a Windows PowerShell Script?
  7. How Can I Add a User to a Group If I Don’t Know the Distinguished Name of That User?
  8. How Can I Delete All the .BAK Files in a Folder That Are More Than 7 Days Old?
  9. How Can I Create a New Registry Key?
  10. How Can I Add a Total Row to an Excel Spreadsheet?
  11. How Can I Extract Information Located Between Two Known Values in a Text File?
  12. How Can I Map a Drive, Copy a File to That Drive, and Then Unmap the Drive?
  13. How Can I Change the Default Highlight Color for a Microsoft Word Document?
  14. How Can I Use Windows PowerShell to Get a List of All My Computers?
  15. How Can I Create a Custom Date Format in Microsoft Excel?
  16. How Can I Separate Hours and Minutes in a Date-Time Value?
  17. How Can I Extract the Text Between the Header and Footer in a Text File?
  18. How Can I Run a Macro After Opening Up Word?
  19. How Can I Enable System Restore Using a Script?
  20. How Can I Keep the Screen From Updating While Running an Excel Script?

October 2006

  1. How Can I Configure an Active Directory Account So the Password Never Expires?
  2. How Can I Use Information in an Excel Spreadsheet to Rename a Set of Folders?
  3. How Can I Delete Duplicate Items From an Array?
  4. How Can I Center-Align a Picture in a Word Document?
  5. How Can I Repeatedly Prompt a User to Enter a File Name?
  6. How Can I Connect to the Junk Mail Folder in Outlook?
  7. How Can I Use Windows PowerShell to Delete All the .TMP Files on a Drive?
  8. How Can I Print a Microsoft Access Report?
  9. How Can I Tell Whether a Number is Even or Odd?
  10. How Can I Split a String Only on Specific Instances of a Character?
  11. How Can I Clear the Contents of Any File Dropped on My Script Icon?
  12. How Can I Create a Table in a SQL Server Database?
  13. How Can I Change an Existing Hyperlink in a Microsoft Word Document?
  14. How Can I Make Sure That No Line in a Text File Exceeds 261 Characters?
  15. How Can I Delete a Record From a Disconnected Recordset?
  16. How Can I Provide a Visual Indicator When Copying Files?
  17. How Can I Compact an Access Database?
  18. How Can I Pass a Drive Letter From a Script to the Command Shell?
  19. How Can I Tell Whether a Specified Table Exists in a SQL Server Database?
  20. How Can I Monitor for the Creation of Different Processes?
  21. How Can I Add a Blank Line Between the Existing Paragraphs in a Word Document?
  22. How Can I Use Windows PowerShell to Pull Records From a Microsoft Access Database?

September 2006

  1. How Can I Determine Whether Terminal Services is Enabled on a Windows Server 2003 Computer?
  2. How Can I Locate Strings That Consist of a Series of Numbers Followed by .ZIP?
  3. How Can I Determine the Background Color of a Spreadsheet Cell?
  4. How Can I Run a Windows PowerShell Script from the Run Dialog Box or a Shortcut?
  5. How Can I Insert Text Into an Existing Microsoft Word Bookmark?
  6. How Can I Verify That All the Items in a List Also Appear in Another List?
  7. How Can I Make the First Character in a Cell Uppercase and All the Other Characters Lowercase?
  8. How Can I Verify That All the Characters in a String are Either A-to-Z (Uppercase Letters) or the Digits 0-through-9 in a HTA?
  9. How Can I Locate All the Folders That Have ArchiveASN in the Path?
  10. How Can I Copy a Worksheet to a New Spreadsheet?
  11. How Can I Tell if Any Internet Explorer Windows Are Open to a Particular Web Site?
  12. How Can I Get a List of All the Databases on a SQL Server Computer?
  13. How Can I Delete All the Users in an Active Directory Group?
  14. How Can I Identify the Last File in a Sequential List of Files?
  15. How Can I Delete Just the Last Line of a Text File?
  16. How Can I Use Windows PowerShell to Automate Microsoft Excel?
  17. How Can I Get a Total Page Count for All the Word Documents in a Folder?
  18. How Can I Alternate Row Colors in an HTA?
  19. How Can I Run a PowerPoint Slide Show From a Script?
  20. How Can I Tell Which Numbers Are Missing From a Sequence of Numbers Found in a Text File?

August 2006

  1. How Can I Set the Document Orientation in Microsoft Word to Landscape?
  2. How Can I Use Windows PowerShell to Locate All the .WMA Files on My Computer?
  3. How Can I Cause a Script to Run Inside an HTA Any Time a User Presses ENTER?
  4. How Can I Append a Location to the Path Environment Variable?
  5. How Can I Determine the First Friday in a Month?
  6. How Can I Add or Subtract Two Hexadecimal Numbers?
  7. How Can I Use Windows PowerShell to Determine the Status of the Guest Account?
  8. How Can I Dynamically Change the Background Color of an HTA?
  9. How Can I Save a File Based on the Day of the Week?
  10. How Can I Minimize or Hide an HTML Application for 30 Seconds?
  11. How Can I Modify the Output of the Ping Command?
  12. How Can I Remove Blank Spaces From File Names?
  13. How Can I Remove Double Double Quotes From a Text File?
  14. How Can I List All the Printers on a Remote Computer?
  15. How Can I Determine the Name of a Script While That Script is Running?
  16. How Can Tell Whether the NumLock Key is On or Off?
  17. How Can I Concatenate Files of the Same Name?
  18. How Can I Replace Text in a Microsoft Word Document?
  19. How Can I Tell Whether a Phrase Occurs At Least Twice in a Text File?
  20. How Can I Determine Whether a Domain is in Mixed Mode or Native Mode?
  21. How Can I Get Access to a Mail Folder That Isn’t a Subfolder of My Outlook Inbox?
  22. How Can I Get a List of All the Senders’ Email Addresses in an Outlook Folder?
  23. How Can I Retrieve Information Required by the Sarbanes-Oxley Act?

July 2006

  1. How Can I Incrementally Rename All the Files in a Folder?
  2. How Can I Get the Process ID for an Executable File, But Only If the Process Has a Specified Owner?
  3. How Can I Display a Message Box That Has No Buttons, and That Disappears After a Specified Period of Time?
  4. How Can I Move the Oldest File in a Folder to a Different Folder?
  5. How Can I Delete All the Email Sent From a Specific Person?
  6. How Can I Replace Selected Lines in an XML File?
  7. How Can I Subtract a Specified Number of Days from a UTC Value?
  8. How Can I Tell If a Specified Worksheet Exists in an Excel Workbook?
  9. How Can I Set the Default Printer Based on the IP Address of the Computer?
  10. How Can I Create a Logon Script That Will Open a User’s Mapped Drives?
  11. How Can I Get the Names of 10 Randomly-Selected Files in a Folder?
  12. How Can I Search For (and Reformat) Highlighted Text in a Word Document?
  13. How Can I Add a COUNTIF Formula to an Excel Spreadsheet?
  14. How Can I Determine Last Month’s Date?
  15. How Can I Load List Box Options From a Text File?
  16. How Can I List All the Empty Folders on a Specified Drive?
  17. How Can I Determine Whether or Not My Local Users are Required to Have a Password?
  18. How Can I Create a Compressed Folder and Add Files to It?
  19. How Can I Test a Dynamic Array to See if the Array is Empty?
  20. How Can I Get the Full Name and Description For My Local User Accounts?

June 2006

  1. How Can I Locate All the Instances of a Particular File on a Computer?
  2. How Can I Bind to an Active Directory User Account Using Windows PowerShell?
  3. How Can I Get a List of the Unique Words Used in a Microsoft Word Document?
  4. How Can I Copy a File Numerous Times and Rename Each of Them from a List in Excel?
  5. How Can I Copy All the Comments From an Excel Worksheet to a Word Document?
  6. How Can I Move a Computer From an Unknown OU into a Known OU?
  7. How Can I Determine Whether a File Exists on a Remote Computer?
  8. How Can I Use Windows PowerShell to Start a Service on a Remote Computer?
  9. How Can I Retrieve a List of All the Files That Have No File Extension?
  10. How Can I Write a Script That Prevents the Screensaver from Starting?
  11. How Can I Write a Script That Accesses All the Subfolders in My Outlook Inbox?
  12. How Can I Insert Text Into a Specific Column of a Text File?
  13. How Can I Get a List of Available Metadata for Microsoft Office Documents?
  14. How Can I Populate a List Box With the CNs of All the OUs in My Domain?
  15. How Can I Add a Right-to-Left Text Box to a Web Page?
  16. How Can I Add Multiple Tables to a Word Document?
  17. How Can I List All the Tables in an Access Database?
  18. How Can I Add Leading Zeroes to All the Lines in a Text File?
  19. How Can I Return the URLs Associated with My Internet Explorer Favorites?
  20. How Can I Dynamically Add Controls to an HTA?
  21. How Can I Configure the System Failure Options on a Windows Server 2003 Computer?
  22. How Can I Find the Process ID Associated with a Batch File?

May 2006

  1. How Can I Search a Word Document for All the Words in Double Brackets?
  2. How Can I Extract Just the File Name from the Full Path to the File?
  3. How Can I Search for Folders That Have a Dot in Their Name?
  4. How Can I Change All the Lowercase Letters in an Excel Worksheet to Uppercase Letters?
  5. How Can I Get a Script to Delete Itself?
  6. How Can I Rename a User Account in a Windows NT 4.0 Domain?
  7. How Can I Get a List of All the .dll Files in a Folder, Along with Their Version Numbers?
  8. How Can I Hide the Command Window When Executing a Command Like net Localgroup Administrators?
  9. How Can I Create a New Excel Spreadsheet at Midnight Each Night?
  10. How Can I Rename a Local User Account on a Windows XP Computer?
  11. How Can I Use a Script to Create a Sequential Series of User Accounts?
  12. How Can I Tell Whether a .GIF File is a Regular Picture File or an Animated Picture File?
  13. How Can I Convert a Global Security Group to a Universal Security Group?
  14. How Can I Rename Files Using File Names I’ve Written to a Text File?
  15. How Can I Add Centered Page Numbers to the Footer of a Word Document?
  16. How Can I Clear the List of URLs That Appear in the Internet Explorer Address Bar?
  17. How Can I Map Network Drives Based on a Computer’s Site?
  18. How Can I Force Users to Type Command-line Arguments in a Specific Order?
  19. How Can I Query a Text File and Retrieve Records That Occurred on a Specific Date?
  20. How Can I Remove Blank Spaces Before and After a String Value?
  21. How Can I Use a Script to Automatically Queue Up Files That I Want to Burn to a CD?
  22. How Can I Determine the Size of All the Items Currently in the Recycle Bin?

April 2006

  1. How Can I Use the RunAs Command to Run a Script Under Alternate User Credentials?
  2. How Can I Print Just the Text Area of an HTA?
  3. How Can I Get a List of All My Internet Cookies?
  4. How Can I Determine the Name of the Local Computer Using WMI?
  5. How Can I Select a Column of Data in Excel and Then Paste that Data into a Text File?
  6. How Can I Reformat Numbers Using a Script?
  7. How Can I Tell Which of Our Windows Server 2003 Computers are Running R2?
  8. How Can I Open a Text File as Unicode?
  9. How Can I Add an Edit Command to the Context Menu for an HTA?
  10. How Can I Change the Title Property of a .WMA File?
  11. How Can I Tell Whether a Computer has a Specific CD in It?
  12. How Can I Distinguish Between Local Users and Domain Users?
  13. How Can I Create a Table and Fill the First Column With a Range of Dates?
  14. How Can I Save a Disconnected Recordset?
  15. How Can I List All the Files on a User’s Desktop?
  16. How Can I Convert a Number to a Date in Excel?
  17. How Can I Locate and Replace Information for a Specific Item in a Spreadsheet?
  18. How Can I Determine the Path to the Folder Where a Script is Running?
  19. How Can I Rename a Word Document Using the First Three Characters in That Document?
  20. How Can I Count the Number of Words in a Text File?

March 2006

  1. How Can I Use a Script to Lock the Taskbar?
  2. How Can I Temporarily Pause a Script in an HTA?
  3. How Can I Change the IP Address Assigned to a Computer?
  4. How Can I Disable the Keep Printed Documents Attribute on a Printer?
  5. How Can I Determine the Default Script Host on a Computer Before I Run a Script?
  6. How Can I Retrieve a List of the Commands Typed Into the Run Dialog Box?
  7. How Can I Write a Script That Will Open a Text File and Shuffle the Words Found in That File?
  8. How Can I Get a List of All the Users Who Have an Alternate Recipient?
  9. How Can I Search for and Highlight Words in a Microsoft Word Document?
  10. How Can I Get a List of Installed Device Drivers?
  11. How Can I Start Windows Explorer Opened to a Specific Folder?
  12. How Can I Determine the Local Path to a Shared Folder?
  13. How Can I Delete a Folder That Has an Apostrophe in the Name?
  14. How Can I Determine the Drive Label of a Drive?
  15. How Can I Write Output to the Screen that Overwrites Whatever is Currently on the Screen?
  16. How Can I Set Scriptomatic So That It Automatically Outputs to a Text File?
  17. How Can I Encode Scripts Within an HTA?
  18. How Can I Configure the Screensaver Used When No One is Logged On to a Computer?
  19. How Can I Save an Excel Spreadsheet, and Then Save a Copy as HTML?
  20. How Can I Change the Internet Explorer Title Bar?
  21. How Can I Read Just the Last Line of a Text file?
  22. How Can I Determine if a Computer is Running Windows Server 2003 and if Service Pack 1 is Installed?
  23. How Can I Right-Align a Single Column in a Word Table?

February 2006

  1. How Can I Re-Launch Internet Explorer if No Other Instances are Running?
  2. How Can I Disable a Service?
  3. How Can I Prevent a Computer from Using the LMHosts File?
  4. How Can I Format an Excel Spreadsheet So It Retains Leading Zeroes?
  5. How Can I Truncate Names to a Maximum of 16 Characters?
  6. How Can I Replace a Local File with a Newer Version Found on a File Server?
  7. How Can I List All the Items in the Run Key in the Registry?
  8. How Can I Specify the Computers a User Can Use to Log On to the Domain?
  9. How Can I Determine Which Account a Script is Running Under?
  10. How Can I Determine the Last Row in an Excel Spreadsheet?
  11. How Can I Convert a DN to this Format: finance.fabrikam.com/Users?
  12. How Can I Determine When a Removable Drive Gets Connected?
  13. How Can I Log the Start Time and the End Time of the Screensaver?
  14. How Can I Count the Number of Times a Word Appears in a Log File?
  15. How Can I Determine Whether a Computer Has Any USB 2.0 Ports?
  16. How Can I Determine the Drive Letter for the Drive My Script is Currently Running On?
  17. How Can I Assign a New Home Drive to a User Who Doesn’t Have One?
  18. How Can I Search for Multiple File Extensions in a Single WQL Query?
  19. How Can I Remove All the Formatting from an Excel Spreadsheet?
  20. How Can I Boldface a Specific Word Throughout a Microsoft Word Document?

January 2006

  1. How Can I Retrieve Information About the Latest Event Added to an Event Log?
  2. How Can I Find the Date of the Oldest Event in an Event Log?
  3. How Can I Count the Number of Computers in a Domain?
  4. How Can I Auto-Delete Specific File Types from the My Pictures Folder?
  5. How Can I Get a List of All the Objects that have been Added to Active Directory Since a Specified Date?
  6. How Can I Display the IP Addresses Associated with a Given MAC Address?
  7. How Can I Add a User to a Group, but Only if that User is a Member of the IT Department?
  8. How Can I Extract a Series of Characters Found in the Middle of a String?
  9. How Can I Tell Which Users are Connected to a Print Queue?
  10. How Can I Change the Size of a Page File?
  11. How Can I Tell Whether a Logon Script is Running on a Workstation or on a Server?
  12. How Can I Get Total Size and Number of Items in an Office Outlook Folder?
  13. How Can I List All the Sub-OUs in an OU?
  14. How Can I Determine Which Day of the Year a Date Falls On?
  15. How Can I Take Ownership of a File or Folder By Using a Script?
  16. How Can I Change the Font Name and Size for an Entire Word Document?
  17. How Can I Remove All the Black-and-White Printers on a Computer?
  18. How Can I Determine Which Text has been Selected in an HTA?
  19. How Can I Purge a Print Queue on a Print Server?
  20. How Can I Move All the Users from One OU to Another OU?
  21. How Can I Remove All the Blank Lines from a Text File?

2005 248

December 2005

  1. How Can I Retrieve the Path to the Program Files Folder on a Computer?
  2. How Can I Change the Footer in an Excel Spreadsheet?
  3. How Can I Get the “Grandparent” of an Object in Active Directory?
  4. How Can I Delete the C$ Share from a Computer?
  5. How Can I Create an HTA that Doesn’t Have a Close Button in the Title Bar?
  6. How Can I Add Additional Worksheets to an Excel Workbook?
  7. How Can I Configure the History Setting in Internet Explorer?
  8. How Can I Disable a Computer Account?
  9. How Can I Delete Everyone Except the Administrator and the Domain Admins Group from the Local Administrators Group?
  10. How Can I Use Alternate Credentials When Searching Active Directory?
  11. How Can I Convert Names to Proper Case?
  12. How Can I Change the Description for a Computer?
  13. How Can I Print Text Files to a Printer Other than the Default Printer?
  14. How Can I Convert an Outlook Email Message into a Text File?
  15. How Can I Change the Location of a User’s Home Drive in Active Directory?
  16. How Can I Remove All the Local Printers from a Computer?

November 2005

  1. How Can I Close a Command Window with a Specific Title?
  2. How Can I Set Word’s Revision View Mode to Final?
  3. How Can I Rename Files Like _JKG1234.jpg to 272_DSC_1234.jpg?
  4. How Can I Get a List of All the Groups Whose Name Starts with G-S-Group?
  5. How Can I Sort Worksheets in a Workbook?
  6. How Can I Lock a Workstation After Five Minutes of Inactivity?
  7. How Can I Verify that ADAM is Installed?
  8. How Can I Import a Fixed-Width File into Microsoft Excel?
  9. How Can I Determine the Height and Width of a Picture File Without Using Windows Media Player?
  10. How Can I Use ADO to Read a Text File Where All the Data is on a Single Line?
  11. How Can I Tell if ActiveX is Enabled in Internet Explorer?
  12. How Can I Get the Command Window to Stay Open After Running a Command-Line Tool?
  13. How Can I Receive Notification Any Time Something is Printed to a Particular Printer?
  14. How Can I Clear an HTA Window?
  15. How Can I Insert Multiple Files Into a Word Document, Putting a Page Break Between Each File?
  16. How Can I List All the Sites in Active Directory as well as All the Servers in Those Sites?
  17. How Can I Add a Hyperlink to an Excel Spreadsheet?
  18. How Can I Determine the ADsPath for the Logged-On User?
  19. How Can I Determine the Name of the Local Administrators Group?
  20. How Can I Change a User’s sAMAccountName?

October 2005

  1. How Can I Start an Application From an HTA?
  2. How Can I Determine an Attribute’s Data Type and Whether It is Single- or Multi-Valued?
  3. How Can I Determine Which Drives are Mapped to Network Shares?
  4. How Can I Determine if an OU is Blocking Group Policy Inheritance?
  5. How Can I Delete a Backup File Created on the Previous Day?
  6. How Can I Remove a Group from the Local Administrators Group?
  7. How Can I Read a Text File on a Remote Computer?
  8. How Can I Verify That a Folder Has Files in It and, If So, Delete Those Files?
  9. Hey, Scripting Guy! How Can I Configure the Hide From Exchange Address Lists Property for All the Contacts in a Domain?
  10. How Can I Add the Last Lines from a Group of Text Files to a Word Document?
  11. How Can I List All the Users in an NT 4.0 Domain?
  12. How Can I Add a User to a Group if That User Belongs to Two Other Groups?
  13. How Can I Get a List of All the Users in an OU and Its Sub-OUs?
  14. How Can I Build an Array from a Column of Data in Excel?
  15. How Can I Determine Which Users are Using the Most Disk Space on a Drive?
  16. How Can I Center an HTA on the Screen?
  17. How Can I Determine Which Version of Access was Used to Create a Database?
  18. How Can I Verify that None of My Local User Accounts have a Blank Password?
  19. How Can I Set Word’s Default File Location to be the User’s Home Directory?
  20. How Can I Get a Script to Close an HTML Page?
  21. How Can I List All the Files in a Folder, Ordered By Creation Date?

September 2005

  1. How Can I Determine if a Particular Patch is Installed?
  2. How Can I Determine the Logon Name for a User?
  3. How Can I Find All the Drives Mapped to a Share and Remap Them?
  4. How Can I Periodically Refresh a Web Page?
  5. How Can I Delete Specific Files in a Specific Folder?
  6. How Can I Add a Domain Group to the Local Administrators Group?
  7. How Can I Monitor the Activity Level of a Process?
  8. How Can I List All the Groups in an OU?
  9. How Can I Copy Column C of One Worksheet to Column A of a Second Worksheet?
  10. How Can I Specify a Window Size for My HTA?
  11. How Can I Turn Off the Windows XP Service Pack 2 Firewall?
  12. How Can I Use a Logon Script to Remove All Mapped Drives?
  13. How Can I Open Word with the Cursor Positioned at the Start of a Specified Line?
  14. How Can I Retrieve Just Audit Failures, Warnings, and Errors from My Event Logs?
  15. How Can I Center Text in an Excel Cell?
  16. How Can I Remove an Item from a List Box in an HTA?
  17. How Can I Clear the Logon Script Path for All My Users?
  18. How Can I Check to See if a User Exists in an NT 4 Domain?
  19. How Can I Remotely Start an Interactive Process?
  20. How Can I Return a List of All the Users Whose User Account Never Expires?
  21. How Can I Add a Shortcut to the Quick Launch Tray?

August 2005

  1. How Can I Change a User’s Primary Group?
  2. How Can I Increment the Last Line in a Text File?
  3. How Can I Get a List of All the Users Whose Passwords Never Expire?
  4. How Can I Determine the 20 Largest Files on a Computer?
  5. Hey, Scripting Guy! How Can I Find All the Users with Remote Access Permissions?
  6. How Can I Determine When the Last Patch From Windows Update was Applied?
  7. How Can I Unhide All the Files in a Folder?
  8. How Can I Determine Which Attributes are Replicated to the Global Catalog?
  9. How Can I Remove All Duplicate Lines From a Text File?
  10. How Can I Start Up and Shut Down a Virtual Server Session?
  11. How Can I Enumerate All the Universal Groups in Active Directory?
  12. How Can I Monitor the Event Logs for the Occurrence of a Specific Event?
  13. How Can I Dynamically Populate a List Box in an HTA?
  14. How Can I Change the Icon for an Existing Shortcut?
  15. How Can I Determine the Beginning and Ending Date of the Previous Month?
  16. How Can I Tell if the Screen Saver is Active?
  17. How Can I Modify a Disk Quota Entry Under Windows 2000?
  18. How Can I List All the Songs in the Windows Media Library?
  19. How Can I Change the Printer Port for a Printer?
  20. How Can I Change File Locations for Microsoft Word?
  21. How Can I Insert a Symbol into a Word Document?
  22. How Can I Determine the Uptime for a Server?
  23. How Can I Search for Two Items in a Text File?

July 2005

  1. How Can I Tell if a Date Falls within a Specified Time Period?
  2. How Can I Determine if a WMI Property is Writeable?
  3. How Can I Include Multiple Subroutines in a Single onClick Parameter in a HTA?
  4. How Can I Tile the Windows on the Desktop?
  5. How Can I Retrieve a List of the System DSNs on a Computer?
  6. How Can I Determine if the Local Administrator Account has been Renamed on a Computer?
  7. How Can I Determine the Current Screen Resolution Being Used on a Computer?
  8. How Can I Determine the Date and Time that a Process Started?
  9. How Can I Retrieve Information About the Printer Driver Used by a Printer?
  10. How Can I Determine When an Active Directory User Account will Expire?
  11. How Can I Share All the Local Printers on a Computer?
  12. How Can I Delete an Active Directory Object that Contains Other Objects?
  13. How Can I Change the User Information in Microsoft Office?
  14. How Can I Tell Which Version of the .NET Framework is Installed on a Computer?
  15. How Can I Monitor Changes to a Registry Key?
  16. How Can I Use a Script to Rename a Printer?
  17. How Can I Get a List of the ODBC Drivers that are Installed on a Computer?
  18. How Can I Cause a User’s Password to Expire?
  19. How Can I Determine When a User Last Changed His or Her Password?
  20. How Can I Launch Two Applications, Wait Until One Program Ends, and Then Close the Other?

June 2005

  1. How Can I Add a Line to the Top of a Text File?
  2. How Can I Change the Background Color of a Cell Depending on the Date?
  3. How Can I List All the Attributes Used by the Computer Class in Active Directory?
  4. How Can I Retrieve a List of OUs that have a Specific Word in Their Name?
  5. How Can I Get the Actual Text of a List Box or Dropdown List Option?
  6. How Can I Determine the Date for the Friday in a Given Week?
  7. How Can I Compare Two String Values Regardless of Letter Case?
  8. Hey, Scripting Guy! How Can I Retrieve the Value of an Active Directory Attribute that has a Hyphen in Its Name?
  9. How Can I Determine if a File Exists and, if It Does, Exit the Script?
  10. How Can I Show Users a Dialog Box That Only Lets Them Select Folders?
  11. How Can I Delete Data from a Spreadsheet Yet Keep All the Formatting?
  12. How Can I Determine Which Domain Controller Authenticated a User?
  13. How Can I Associate a Network Connection with an IP Address?
  14. How Can I Change the Size of the Temporary Internet Files Folder?
  15. How Can I Determine the Number of Items Generated by the Split Function?
  16. How Can I Clear a Text Box in an HTA?
  17. How Can I Hide a Specific Toolbar in Microsoft Word?
  18. How Can I Tally Items in a Text File?
  19. How Can I List All the User Profiles on a Computer?
  20. Hey, Scripting Guy! How Can I List All the User Profiles on a Computer?
  21. How Can I Display More Than 1,023 Characters in a Custom Message Box?
  22. How Can I Retrieve the Path to the %windir% Folder on a Computer?

May 2005

  1. How Can I Open an Excel Workbook and Retrieve the Names of All the Worksheets?
  2. How Can I Change the “Copy Music to This Location Folder” in Windows Media Player?
  3. How Can I Get Just the User Name When Using the Win32_ComputerSystem Class?
  4. How Can I Extract Word Paragraphs That Use a Specific Style?
  5. How Can I Use ADO to Open a Text File That has Spaces in the File Name?
  6. How Can I Correlate Logical Drives and Physical Disks?
  7. How Can I Remove the Last Carriage Return-Linefeed in a Text File?
  8. How Can I Switch Between Using a Proxy Server and Not Using a Proxy Server?
  9. How Can I Generate Random Numbers Using a Script?
  10. Hey, Scripting Guy! How Can I Access Active Directory on a Specific Domain Controller?
  11. How Can I Lower the Priority of a Process Using a Script?
  12. How Can I Display the Vertical and Horizontal Sizes of a .JPG File?
  13. How Can I Get a List of All the Disabled User Accounts in Active Directory?
  14. How Can I Rename a Local Area Connection?
  15. How Can I Add an Email Address to the proxyAddresses Attribute?
  16. How Can I Create a Shortcut in My Network Places?
  17. How Can I Make Internet Explorer Check for a New Version Each Time I Visit a Web Page?
  18. How Can I Determine the Week of the Month a Date Falls In?
  19. How Can I Exit a For Each Loop?
  20. How Can I Insert Files into a Word Document?
  21. How Can I Add a Site to Internet Explorer’s Restricted Sites Zone?

April 2005

  1. How Can I Change the User and Computer Account Description Attributes Each Time a User Logs On?
  2. How Can I Purge All the Print Jobs on a Windows 2000 Print Server?
  3. How Can I Tell if an Excel Workbook is Open and, If It Isn’t, Open It?
  4. How Can I Add All the Users from an Existing Active Directory Group to a New Group?
  5. How Can I Configure a Computer to Use a Dynamically-assigned DNS Server?
  6. How Can I Add Two Blank Lines Between Each Line in a Text File?
  7. Why Does My Performance Monitoring Script Keep Returning the Same Incorrect Values?
  8. How Can I Pass Command-Line Variables to an HTA When It Starts?
  9. How Can I Tell Whether a Group Member is a User, a Computer, or Another Group?
  10. How Can I Determine the Version Number of a File?
  11. How Can I Search a Text File for 9-Digit Numbers?
  12. How Can I Display a Multi-Valued Attribute Returned from an Active Directory Search?
  13. How Can I Eliminate Duplicate Names in a Text File?
  14. Hey, Scripting Guy! How Can I Bind to a User Account Using Something Other Than the CN Attribute?
  15. How Can I Insert a Column into a Spreadsheet?
  16. How Can I Get a List of All the .PST Files on a Computer?
  17. How Can I Print a Test Page to a Printer?
  18. How Can I Convert a Comma-Separated Values File to a Tab-Separated Values File?
  19. How Can I Delete a Folder and All Its Subfolders?
  20. How Can I Monitor for Different Types of Events With Just One Script?
  21. How Can I Convert 1,000 .RTF Files to Word Documents?

March 2005

  1. How Can I Determine the Size of the My Documents Folder?
  2. How Can I Copy and Rename a Worksheet in the Same Workbook?
  3. How Can I Clear a List Box in an HTA?
  4. How Can I Add a Word to a Text File if That Word Isn’t Already in the File?
  5. How Can I Write Double Quotes to a Text File?
  6. How Can I Set an Active Directory Attribute Value to NULL?
  7. How Can I Save a Single Excel Worksheet to a CSV File?
  8. How Can I Be Notified Any Time a Network Cable Gets Unplugged?
  9. How Can I Create an Environment Variable Using a Script?
  10. How Can I Move Files Based on Their File Extension?
  11. How Can I Display A Progress Bar (or Something Similar) While My Script Runs?
  12. How Can I Determine Which USB Devices are Connected to a Computer?
  13. How Can I Automatically Dismiss a Message Box After a Specified Length of Time?
  14. How Can I Delete a Table from a Jet Database?
  15. How Can I Temporarily Add a Group to Another Active Directory Group?
  16. How Can I Determine Which Version of Internet Explorer is Installed on a Computer?
  17. How Can I Get a List of All the Domains in a Forest?
  18. How Can I Tell If a File Exists on a CD or DVD Drive?
  19. How Can I Delete a Single Registry Value?
  20. How Can I Determine the Elapsed Time Between Two Dates?
  21. How Can I Create a Folder on the Start Menu?
  22. How Can I Use a Multi-Select Dialog Box in a Script?

February 2005

  1. How Can I Determine if a Users’ Folder Exists on a Computer?
  2. How Can I Sort the Contents of a Text File?
  3. How Can I Write Binary Data to the Registry?
  4. How Can I Read Text From a File and Then Rename the File Using the Text I Just Read?
  5. How Can I Tell Whether a Web Page is Accessible?
  6. How Can I Create a GUID Using a Script?
  7. How Can I List the Files in a Folder and All Its Subfolders?
  8. How Can I Count the Number of Times a User has Logged on to a Computer?
  9. How Can I List Open Sessions and Open Files on a Computer?
  10. How Can I Add a Hyperlink to a Word Document?
  11. How Can I Add a Web Site to the Trusted Sites Zone?
  12. How Can I Use a Wildcard Character to Delete Folders?
  13. How Can I Disable the Guest Account on a Computer?
  14. How Can I Change the Target of a Desktop Shortcut?
  15. How Can I Find and Replace Text in a Text File?
  16. How Can I Password-Protect an Excel Spreadsheet?
  17. How Can I Mask Passwords Using an InputBox?
  18. How Can I Determine Whether or Not a Group Has Any Members?
  19. How Can I Get a List of All My Windows Server 2003 Computers?
  20. How Can I Change the Working Folder of a Script?

January 2005

  1. How Can I Make Changes to and Then Re-Save an Existing Excel Spreadsheet?
  2. How Can I Show Users a Dialog Box for Selecting Files?
  3. How Can I Determine the System Time on a Computer?
  4. How Can I Retrieve Information From My Event Logs Regarding Unsuccessful Logons?
  5. How Can I Read Just a Single, Specified Line from a Text File?
  6. How Can I Determine the Next Available Drive Letter on a Computer?
  7. How Can I Find and Move an Active Directory Computer Account?
  8. How Can I Tell Which Switches Were Used When Starting an Executable File?
  9. How Can I Change the Caption for the My Computer Icon?
  10. How Can I Make a Read-Only File Writeable?
  11. How Can I Change the Legal Warning Message Using a Script?
  12. How Can I Tell if a Folder Has Any Files with a Specific File Extension?
  13. How Can I Map a Printer, But Only If the User Doesn’t Have a Local Printer?
  14. How Can I Access a Type Library From Within a Script?
  15. How Can I Put the User Name into the Footer of a Microsoft Word Document?
  16. How Can I Determine Which Version of Word is Installed on a Computer?
  17. How Can I Share a Folder on a Remote Computer?
  18. How Can I Tell On What Date an Active Directory User Account Was Created?
  19. How Can I Prompt a User to Delete (or Not Delete) a Computer Account?
  20. How Can I Return Only the Last Record Written to an Event Log?
  21. How Can I Determine the Account a Process is Running Under?

2004 98

December 2004

  1. How Can I Save Word Documents as Text Files By Using a Script?
  2. How Can I Tell Whether a Group is a Security Group or a Distribution Group?
  3. How Can I Return a List of Downloaded Controls and Applets for Internet Explorer?
  4. How Can I Connect to a Folder When There’s an Apostrophe in the Folder Name?
  5. How Can I Get a List of All the Domain Controllers in My Domain?
  6. How Can I Grab a URL From the Clipboard and Then Open That Web Site in a Browser?
  7. How Can I Rename an Active Directory Group?
  8. How Can I Run a Script Under Alternate Credentials?
  9. How Can I Map Drives Based on Membership in a Group?
  10. How Can I Rename Files Based on the File’s Creation Date?
  11. How Can I Determine the Executable File Corresponding to a Shortcut?
  12. How Can I Return a List of All My Computers Except Those in a Specified OU?
  13. How Can I Assign a New UPN to All My Users?
  14. How Can I Determine the SID for a User Account?
  15. How Can I Prevent a Local User From Changing His or Her Password?
  16. Can I Combine Multiple Text Files Using a Script?

November 2004

  1. Can I Edit .INI Files Using a Script?
  2. How Can I Attach a File to an Email Sent Using CDO?
  3. How Can I Retrieve Disk Quota Information for a Single User?
  4. How Can I Run a Script Against a Range of IP Addresses?
  5. How Can I List the Members of a Group in Alphabetical Order?
  6. How Can I Put New Users in the Same OU as the Person Creating Their Accounts?
  7. Can I Use a Script to Determine the Size of a Folder on a Remote Computer?
  8. Hey, Scripting Guy! Is There Any Way to Determine the Default Printer On a Computer?
  9. Can I Read an Entire Text File Rather Than Reading It Line-by-Line?
  10. Can I Lock a Workstation Using a Script?
  11. How Can I Tell If an OU Has Any User Accounts In It?
  12. Can I Pin a File to the Start Menu by Using a Script?
  13. Can I Create and Delete a DSN Using a Script?
  14. Can I Use a Script to Rename All the Files in a Folder?
  15. How Can I Change the Internet Explorer Home Page?
  16. How Can I Work with a CN that Has a Comma in It?
  17. How Can I Delete All Files Older Than a Specified Date?
  18. How Can I Play a Sound From Within a Script?
  19. How Can I Delete the Files in the Temporary Internet Files Folder?
  20. How Can I Make Selections from a Form When Using a Script?

October 2004

  1. How Can I Tell Whether a Value Exists in the Registry?
  2. How Can I Create a CSV File?
  3. How Can I Change the Screensaver Timeout Value?
  4. Hey, Scripting Guy! Can I Retrieve Just Failure Events from the Security Event Log?
  5. How Can I Send Data from One Script to Another?
  6. How Can I Display a Hyperlink in a Message Box?
  7. How Can I Determine the OU a User Account Belongs To?
  8. How Can I Get a List of All the Files in a Folder and Its Subfolders?
  9. How Can I Change a Read-only File to a Read-write File?
  10. How Can I Pick Out and Save Specific Lines in a Text File?
  11. How Can I Change a User’s Password?
  12. How Can I Determine if My Users Have Certain Files on Their Computers?
  13. How Can I Count the Number of Lines in a Text File?
  14. How Can I Automatically Run a Script Any Time a File is Added to a Folder?
  15. How Can I Add a Domain User to a Local Administrators Group?
  16. How Can I Determine the Owner of a File?
  17. How Can I Tell Which Scripts are Running on a Computer?
  18. How Can I Pause a Script and Then Resume It When a User Presses a Key on the Keyboard?
  19. How Can I Print Text Files Using a Script?
  20. How Can I Write to the Comments Field of a Document?

September 2004

  1. How Can I Compare the Memberships of Two Groups?
  2. How Can I Tell Which Service Packs Have Been Installed on a Computer?
  3. How Can I Get a List of the Devices That Aren’t Working?
  4. How Can I Terminate a Process with a Specific PID?
  5. How Can I Get a List of Exchange Servers Assigned to My Users?
  6. How Can I Display Multiple Lines of Output in a Web Page?
  7. How Can I Manage Scheduled Tasks Using Scripts?
  8. How Can I Determine if a Computer is a Laptop or a Desktop Machine?
  9. How Can I Tell if a Computer Has a DVD Drive Installed?
  10. How Do I Bind to a User Account in a Sub-OU?
  11. How Do I Get Rid of Extraneous Spaces in a String?
  12. How Can I Use Both Command-line Arguments and a Default Value?
  13. Why Doesn't My Ping Script Run on Windows 2000 Computers?
  14. Why Doesn't My LIKE Query Work on Windows 2000?
  15. How Can I Tell Which Account a Service is Running Under?
  16. How Can I Read in IP Addresses and Use Them in a Script?
  17. How Can I Determine the Version Number of an Executable File?
  18. How Can I Tell if a Server has Rebooted?
  19. How Can I Be Notified Any Time a Service Goes Down?
  20. How Can I Enumerate All the Objects in an Active Directory OU?

August 2004

  1. How Can I Prompt a User for Input?
  2. How Can I Stop a Script Partway Through?
  3. How Can I Determine the Day of the Week?
  4. Can I Change the Command Window Title When Running a Script?
  5. Why am I Getting an Error when Trying to Determine an IP Address?
  6. Why Doesn't My Search Return All My User Accounts?
  7. Can I Change the Current Directory When Running a Script?
  8. How Can I Determine Which Groups a User Belongs To?
  9. How Can I Determine if a Folder Exists on a Computer?
  10. How Can I Determine How Long It Takes a Script to Run?
  11. How Can I Save Output to a Text File?
  12. How Can I Give a User a Yes/No Prompt?
  13. Can I Copy Script Output to the Clipboard?
  14. Can I Read a Text File From the Bottom Up?
  15. Can I Get a List of All My User Accounts?
  16. How Can I Call the Dir Command?
  17. Can I Enable the Caps Lock Key?
  18. How Can I Use Long File Names as Parameters?
  19. How Can I Determine if a User is a Local Administrator?
  20. How Do I Change the Title of a Message Box?
  21. How Can I Get Yesterday’s Date?
  22. Registry Script Doesn't Work

2008–2012 →