Scripting Blog [archived]

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

retrieving input - Scripting Blog [archived]

Hey, Scripting Guy! How Can I Prompt a User for Information and Then Pass That Information to a Command-Line Tool?

February 7, 2007 Feb 7, 2007 02/7/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I prompt a user for information and then pass that information to a command-line tool?-- SD(image) (image) (image) Hey, SD. efh;r9d/fjwf Sorry; let’s try that again. j ewewrj 2gr CX # 2kkkkw Sorry; the Scripting Guy who writes this column is having a little difficulty moving his arms today. Last night ...

How Can I Repeatedly Prompt a User to Enter a File Name?

October 25, 2006 Oct 25, 2006 10/25/06
ScriptingGuy1
(image) Hey, Scripting Guy! I have approximately 100 Excel files (all with names like 9365.xls) in a folder. I’d like to prompt a user for a file name, open the file, retrieve information from a specified cell, then close the file (ideally Excel would never appear on screen). I’d then like to prompt the user to enter another file name. ...

How Can I Clear the Contents of Any File Dropped on My Script Icon?

October 17, 2006 Oct 17, 2006 10/17/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I write a script that will clear the contents of any file that I drag and drop on the script icon?-- SN(image) (image) (image) Hey, SN. Say, you didn’t by any chance misplace a few hundred thousand insects did you? OK; just thought we’d ask. This past weekend the Scripting Guy who writes this column ...

How Can I Access a Type Library From Within a Script?

January 12, 2005 Jan 12, 2005 01/12/05
ScriptingGuy1
(image) Hey, Scripting Guy! How can I access a type library from within a script?-- XA(image) (image) (image) Hey, XA. For those of you unfamiliar with the term, a type library is a file or a component that contains type information for a COM object; type information describes the object and the things you can do with it. Among the ...

How Can I Send Data from One Script to Another?

October 25, 2004 Oct 25, 2004 10/25/04
ScriptingGuy1
(image) Hey, Scripting Guy! A while back you showed how we could use the InputBox function to prompt a user to enter a value we could then use in our script. What I’d like to know is, is there any way I can take that value and use it in another script?-- JW(image) (image) (image) Hey, JW. We’re guessing here, but apparently you’d ...