Showing tag results for retrieving input

Hey, Scripting Guy! How can I prompt a user for information and then pass that information to a command-line tool?-- SD 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 the Scripting Son thought it would be “...

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 do that?...

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 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 had to drive across the state to attend a...

Hey, Scripting Guy! How can I access a type library from within a script?-- XA 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 information found in a type library are the ...

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 Hey, JW. We’re guessing here, but apparently you’d like to have a script that, among other things...