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…
Year: 2005
How Can I Lock a Workstation After Five Minutes of Inactivity?
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…
How Can I Verify that ADAM is Installed?
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…
How Can I Import a Fixed-Width File into Microsoft Excel?
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…
How Can I Determine the Height and Width of a Picture File Without Using Windows Media Player?
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,…
How Can I Use ADO to Read a Text File Where All the Data is on a Single Line?
Hey, Scripting Guy! I have a fixed-width text file which includes first name (6 characters), last name (13 characters), and department (9 characters) all on a single line. How do I read that using ADO?– DW Hey, DW. Well, to be perfectly honest, we don’t think you can read a file like this using ADO…
How Can I Tell if ActiveX is Enabled in Internet Explorer?
Hey, Scripting Guy! How can I tell if ActiveX is enabled in Internet Explorer?– JV Hey, JV. You just had to ask this question, didn’t you? Actually, this isn’t a particularly hard question to answer, it’s just a little complicated. But that has to do more with the way Internet Explorer is configured than it…
How Can I Get the Command Window to Stay Open After Running a Command-Line Tool?
Hey, Scripting Guy! How can I get the command window to stay open after running a tool like Ping or Ipconfig?– DB Hey, DB. Now this question takes us back. Back when one of the Scripting Guys first started here at Microsoft many people thought WMI and ADSI were way too hard for script writers…
How Can I Receive Notification Any Time Something is Printed to a Particular Printer?
Hey, Scripting Guy! How can I receive notification any time something is printed to a particular printer?– IL Hey, IL. You know, one of the Scripting Guys once had a summer job in an organization where the only decent printer in the entire building was kept in the administrative assistant’s office. We can attest, from…
How Can I Clear an HTA Window?
Hey, Scripting Guy! How can I clear an HTA window?– DF Hey, DF. Well, to tell you the truth, if you’d ever seen at least one of the Scripting Houses you wouldn’t be asking us if we knew how to clear a window; it’s pretty obviously some of us don’t. (In our defense, though, if…