Showing archive results for 2005

Hey, Scripting Guy! How can I copy column C of one worksheet to column A of a second worksheet?-- JP Hey, JP. Well, that’s easy: you just open Excel, highlight column C, press Ctrl+C, put the cursor in column A1 of the second worksheet, and then press Ctrl+V. There you go, and thanks for your question. Oh, right: you wanted to know how to do thi...

Hey, Scripting Guy! How can I specify a particular window size for my HTA?-- RN Hey, RN. We can’t speak for Dear Abby, Ann Landers or any other daily columnist, but the Scripting Guys are always on the lookout for a question that can be answered using a single line of code. That’s the Holy Grail for daily columnists: one and done. And, to the be...

Hey, Scripting Guy! How can I turn off the Service Pack 2 firewall?-- JC Hey, JC. You know, if there’s a drawback to working at Microsoft (and if our manager is reading this we hasten to add that there are no drawbacks to working at Microsoft) it’s this: no matter what you do some people will be glad you did it and others will be … not so glad …...

Hey, Scripting Guy! How can I use a logon script to remove all mapped drives each time a user logs on?-- VS Hey, VS. You know, we’re glad you specifically mentioned the term “logon script” in your question. Why? Well, one of the drawbacks to mapping and unmapping network drives is the fact that there are no WMI classes capable of performing the...

Hey, Scripting Guy! How can I open Word with the cursor positioned at the start of a specified line?-- PS Hey, PS. You know, we Scripting Guys have decided that we don’t like Microsoft Word anymore. How come? Well, as Scripting Guys we like to find solutions to seemingly-unsolvable problems: any time we can find a workaround for something that l...