Showing results for October 2007 - Page 3 of 5 - Scripting Blog [archived]

Oct 17, 2007
Post comments count0
Post likes count0

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

ScriptingGuy1
ScriptingGuy1

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 it’s pub...

Scripting Guy!VBScriptOffice
Oct 12, 2007
Post comments count0
Post likes count0

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

ScriptingGuy1
ScriptingGuy1

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 don’...

Scripting Guy!VBScriptstorage
Oct 11, 2007
Post comments count0
Post likes count0

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

ScriptingGuy1
ScriptingGuy1

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 that the...

Scripting Guy!VBScriptOffice
Oct 10, 2007
Post comments count0
Post likes count0

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

ScriptingGuy1
ScriptingGuy1

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 isn’t ev...

Scripting Guy!VBScriptActive Directory
Oct 9, 2007
Post comments count0
Post likes count0

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

ScriptingGuy1
ScriptingGuy1

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 insert...

Scripting Guy!VBScriptOffice