Showing archive results for 2005

Nov 22, 2005
Post comments count0
Post likes count0

How Can I Sort Worksheets in a Workbook?

ScriptingGuy1

Hey, Scripting Guy! How can I sort worksheets in a workbook?-- FS Hey, FS. How can you sort worksheets in a workbook? Well, to tell you the truth, not as easily as we had hoped you could sort worksheets in a workbook. This doesn’t mean it can’t be done; it just means that the process is a tiny bit convoluted. Because of that, don’t feel bad if y...

Scripting Guy!VBScriptOffice
Nov 21, 2005
Post comments count0
Post likes count0

How Can I Lock a Workstation After Five Minutes of Inactivity?

ScriptingGuy1

Hey, Scripting Guy! How can I lock a workstation after five minutes of inactivity, something recommended to us by our auditors?-- NM Hey, NM. To tell you the truth, we don’t know. Locking a computer remotely can be a bit of a problem; for more information on that, take a look at one of our columns from a year ago. On top of that, you face the pr...

Scripting Guy!VBScriptoperating system
Nov 18, 2005
Post comments count0
Post likes count0

How Can I Verify that ADAM is Installed?

ScriptingGuy1

Hey, Scripting Guy! How can I verify that ADAM is installed?-- CW Hey, CW. Although former President Ronald Reagan is usually given credit for the phrase “Trust but verify,” we’ve always thought that sounded more like the sort of thing a system administrator would say: “Of course I trust you when you say you installed ADAM on that computer. I ju...

Scripting Guy!VBScriptoperating system
Nov 17, 2005
Post comments count0
Post likes count0

How Can I Import a Fixed-Width File into Microsoft Excel?

ScriptingGuy1

Hey, Scripting Guy! How can I import a fixed-width file into Microsoft Excel?-- JP Hey, JP. We have a confession to make here, something we’re terribly ashamed of: for a moment - just for a moment, mind you - we doubted Microsoft Excel. Yes, we know: how could we do such a thing? All we can say is that we made a mistake, and we’re sorry. For som...

Scripting Guy!scripting techniquesVBScript
Nov 16, 2005
Post comments count0
Post likes count0

How Can I Determine the Height and Width of a Picture File Without Using Windows Media Player?

ScriptingGuy1

Hey, Scripting Guy! Awhile back you showed us a method to determine the height and width of a picture file. However, that solution required us to import all our picture files into Windows Media Player. Isn’t there another way to get this information, one that doesn’t require Windows Media Player?-- RP Hey, RP. You see, that’s what happens any ti...

Scripting Guy!VBScriptmultimedia