Showing archive results for 2007

Oct 24, 2007
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Move Files Based on a Value in the File Name?

ScriptingGuy1

Hey, Scripting Guy! I have a bunch of files that I need to move to new folders; the folder a given file will be moved to is based on the year, a value that appears in the file name. How can I write a script to move these files?-- LP Hey, LP. Before we launch into today’s column, we should clarify a couple of points which came up in an “Editor’s ...

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

Hey, Scripting Guy! How Can I Extract All the Text Between Two Tags in a Text File?

ScriptingGuy1

Hey, Scripting Guy! I have a whole bunch of text files in a folder. I need to open each of these files, extract everything between the <filecount> and </filecount> tags, and then write that information to a separate file. How can I do that?-- RP Hey, RP. You know, the other day the Scripting Guy who writes this column and the Scripti...

Scripting Guy!scripting techniquesVBScript
Oct 22, 2007
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Convert a Number to a Date and Then Back in Excel?

ScriptingGuy1

Hey, Scripting Guy! We have a spreadsheet that includes numbers like this: 31738. However, this isn’t supposed to be a number, it’s actually supposed to be a date: 11/22/1986. How can I convert these numbers to dates and then, if needed, convert those dates back to numbers?-- TC Hey, TC. Yes, as a matter of fact it did take the Scripting Guy who...

Scripting Guy!VBScriptMicrosoft Excel
Oct 19, 2007
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Retrieve a List of Unique Users from the Security Event Log?

ScriptingGuy1

Hey, Scripting Guy! How can I retrieve a list of unique users from the Security event log?-- KM Hey, KM. Before we tackle your question we should probably address a question sent in by another reader: Hey, Scripting Guy! Whatever happened to Monday? Having been gone on vacation all last week, I was combing through the Hey, Scripting Guy! ar...

Scripting Guy!VBScriptsecurity
Oct 18, 2007
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Tell if a Computer is Bluetooth-Enabled?

ScriptingGuy1

Hey, Scripting Guy! How can I tell if a computer is Bluetooth-enabled?-- RR Hey, RR. You know, any time the Scripting Guys get asked something like this, one question immediately pops into our minds: “So where did the name Bluetooth come from anyway?” As it turns out, the Bluetooth “personal area networking” protocol was named in honor of Harald...

Scripting Guy!VBScriptdesktop management