Showing archive results for 2007

Sep 5, 2007
Post comments count0
Post likes count0

How Can I Add a Background Picture to an Excel Worksheet?

ScriptingGuy1

Hey, Scripting Guy! How can I add a background picture to an Excel worksheet?-- GA Hey, GA. You know, being the health-conscious type, each morning the Scripting Guy who writes this column eats some non-fat raspberry yogurt … right before he eats his daily doughnut. (But don’t worry: it’s a medically-proven fact that eating yogurt counteracts an...

Scripting Guy!OfficeMicrosoft Excel
Sep 1, 2007
Post comments count0
Post likes count0

How Can I Remove All the Non-Alphabetic Characters in a String?

ScriptingGuy1

Hey, Scripting Guy! How can I remove all the non-alphabetic characters in a string?-- CD Hey, CD. You know, typically the Scripting Guys don’t play favorites; we treat all our readers and all the questions we receive exactly the same. (OK, so, technically that means that, for the most part, we simply ignore all our readers as well as all the que...

Scripting Guy!scripting techniquesVBScript
Aug 31, 2007
Post comments count0
Post likes count0

How Can I Execute a Scheduled Task in Windows Vista?

ScriptingGuy1

Hey, Scripting Guy! I understand that, in Windows Vista, I can write a script that will cause a scheduled task to immediately execute. How do I do that?-- KW Hey, KW. Before we answer today’s question, we’d like to take a moment to say a few things in memory of our colleague, Scripting Guy Dean Tsaltas. Not that Dean has died or anything; physic...

Scripting Guy!VBScriptoperating system
Aug 30, 2007
Post comments count0
Post likes count0

How Can I Reverse All the Lines in a Text File?

ScriptingGuy1

Hey, Scripting Guy! How can I “rotate” a text file 180 degrees? I need the last line in the file to become the first line, the first line in the file to become the last line, and all the lines in between to switch places as well.-- BJM Hey, BJM. You know, when most people think of the Scripting Guys they think, “OK, sure, those guys are absolut...

Scripting Guy!scripting techniquesVBScript
Aug 29, 2007
Post comments count0
Post likes count0

How Can I Get a List of Appointments for a Specific Month?

ScriptingGuy1

Hey, Scripting Guy! How can I get a list of my appointments for a specific month (for example, all my appointments for December, 2007)?-- HG Hey, HG. We’ll get to your question in just a moment. Before we do that, however, the Scripting Guy who writes this column wants to take a little time and enjoy the last few days of August (and, in effect,...

Scripting Guy!VBScriptOffice