Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

June 2005 - Page 3 of 5 - Scripting Blog [archived]

How Can I Delete Data from a Spreadsheet Yet Keep All the Formatting?

June 16, 2005 Jun 16, 2005 06/16/05
ScriptingGuy1
(image) Hey, Scripting Guy! How can I delete data from a spreadsheet yet keep all the formatting?-- TB(image) (image) (image) Hey, TB. From your email it sounds like you have a script that periodically replaces data in a spreadsheet with new, up-to-date values. The spreadsheet has been preformatted, and what you’d like to do is delete ...

How Can I Determine Which Domain Controller Authenticated a User?

June 15, 2005 Jun 15, 2005 06/15/05
ScriptingGuy1
(image) Hey, Scripting Guy! In my logon script how can I determine the name of the domain controller that authenticated the user?-- CK(image) (image) (image) Hey, CK. You know, one of the unwritten rules for being a Scripting Guy is that you should never do anything hard more than once a week. (Why is this an unwritten rule? Mainly because...

How Can I Associate a Network Connection with an IP Address?

June 14, 2005 Jun 14, 2005 06/14/05
ScriptingGuy1
(image) Hey, Scripting Guy! How can I determine the local area connection that’s associated with a particular IP address?-- SH(image) (image) (image) Hey, SH. Believe it or not, this is a fairly complicated procedure, and for two reasons. To begin with, we have to use two separate WMI classes - Win32_NetworkAdapter and ...

How Can I Change the Size of the Temporary Internet Files Folder?

June 13, 2005 Jun 13, 2005 06/13/05
ScriptingGuy1
(image) Hey, Scripting Guy! How can I change the amount of disk space set aside for Internet Explorer’s temporary files folder?-- AD(image) (image) (image) Hey, AD. The first draft of this column we were able to bang out in no time; after all, it consisted entirely of this: Beats us. But after discussing how valuable an answer like that ...

How Can I Determine the Number of Items Generated by the Split Function?

June 10, 2005 Jun 10, 2005 06/10/05
ScriptingGuy1
(image) Hey, Scripting Guy! I know I can use the Split function to split a line into individual items. But how can I tell how many “splits” I ended up with; that is, how many individual items did I generate from a single line?-- SA(image) (image) (image) Hey, SA. For those of you who are relative newcomers to scripting (or those of you...