Scripting Blog

A place to learn about PowerShell and share stories of automation

Hey, Scripting Guy! How Can I Copy Data from Excel to PowerPoint?

Hey, Scripting Guy! As part of a demonstration I do on a regular basis, I’d like to be able to open an Excel spreadsheet, copy all the information on Sheet 1, and then paste that data into a new PowerPoint slide. How can I do all that using a script?-- JG Hey, JG. You know, the Hey, Scripting Guy! column is always written the day before ...

Hey, Scripting Guy! How Can I Map Drives Based on IP Address?

Hey, Scripting Guy! I have been using your script that maps drives based on group membership, and it works just fine. However, I need to modify the script so that drive mappings are also based on the location of the computer (more specifically, on the computer IP address). For example, we have a remote site that uses an ISDN connection and I...

Hey, Scripting Guy! How Can I Retrieve Hyperlink Information From an Office Excel Spreadsheet?

Hey, Scripting Guy! I have an Office Excel document that includes a hyperlink linked to an email address. The text in the spreadsheet simply says Yes. How can I write a script that retrieves the underlying email address?-- AK Hey, AK. You’ll have to forgive us for being a little distracted today. Today is Thursday, October 11th, the day ...

Hey, Scripting Guy! How Can I Search Multiple OUs in Active Directory?

Hey, Scripting Guy! I have an HTA that searches Active Directory for user accounts and then displays those user names. We have 10 OUs in Active Directory, but I only want to retrieve the users from three of those OUs. How do I do that?-- DP Hey, DP. Here’s a little secret for you: it’s very easy to tell when a writer is getting lazy and...

Hey, Scripting Guy! How Can I Insert Blank Rows (and Formulas) Into an Office Excel Worksheet?

Hey, Scripting Guy! I have some extremely large Office Excel worksheets, and I need to insert a blank row every 240 lines; in that new row I then need to insert a formula that calculates the average of the preceding 240 rows. As you might expect, this is extremely tedious, and I have a lot of these worksheets. How can I write a script that ...