Showing archive results for 2006

Nov 8, 2006
Post comments count0
Post likes count0

How Can I Create a Custom Date Format in Microsoft Excel?

ScriptingGuy1

Hey, Scripting Guy! In Microsoft Excel, how can I display a date like 01/20/2006 using this format: 20060120?-- CM Hey, CM. Who do we make the check out to again? And for how much? Oh, sorry. After attending a parent meeting for the Scripting Son’s new baseball team the Scripting Guy who writes this column naturaly assumes that anyone who asks him...

Scripting Guy!VBScriptOffice
Nov 7, 2006
Post comments count0
Post likes count0

How Can I Separate Hours and Minutes in a Date-Time Value?

ScriptingGuy1

Hey, Scripting Guy! In determining system uptime I get back a value like 65.75 hours. How can I convert this value to "65 hours and 45 minutes"?-- JM Hey, JM. We’ll see what we can do for you, but we have to be honest: this is a very sad day for the Scripting Guys. Thanks to the baseball playoffs the Scripting Guy who writes this column had never ...

Scripting Guy!scripting techniquesVBScript
Nov 6, 2006
Post comments count0
Post likes count0

How Can I Extract the Text Between the Header and Footer in a Text File?

ScriptingGuy1

Hey, Scripting Guy! How can I extract the text between the header and footer in a text file?-- LL Hey, LL. Before we answer your question we should point out that, depending on when you’re reading this, you might be missing Day 1 of Windows PowerShell Week. Even as we speak the lovely and talented Jean Ross could be presenting an introduction to W...

Scripting Guy!scripting techniquesVBScript
Nov 3, 2006
Post comments count0
Post likes count0

How Can I Run a Macro After Opening Up Word?

ScriptingGuy1

Hey, Scripting Guy! How can I run a specified Word macro after opening Word using a script?-- JD Hey, JD. You know, when they first tested the atomic bomb a number of physicists had legitimate fears that the bomb might set off an unstoppable chain reaction that would end up destroying the entire world. We have to admit that, when we read your ques...

Scripting Guy!VBScriptOffice
Nov 2, 2006
Post comments count0
Post likes count0

How Can I Enable System Restore Using a Script?

ScriptingGuy1

Hey, Scripting Guy! How can I enable Windows XP’s System Restore using a script?-- RL Hey, RL. Thanks for the question; the Scripting Guy who writes this column is running way late today, the clock is ticking, and he was desperately in need of a question a he could answer without having to use a lot of code. A question about enabling System Restor...

Scripting Guy!VBScriptdesktop management