Scripting Blog

A place to learn about PowerShell and share stories of automation

How Can I Tell Whether a Laptop Computer is Running Off Batteries?

Hey, Scripting Guy! How can I tell whether a laptop computer is running off batteries?-- TJ Hey, TJ. Ah, yes: batteries. Back in December the Scripting House lost power for six days. Was the Scripting Guy who writes this column concerned? Of course not. After all, he was fully prepared for an emergency like that: he had four (count ‘em: ...

How Can I Let Users Choose a Default Printer From a List of Printers?

Hey, Scripting Guy! In a logon script, how can I enable users to choose a default printer from a list of the printers installed on their computer?-- JD Hey, JD. You know, a lot of people write in to say, “Hey, Scripting Guys! Why do you limit yourselves to system administration scripting? Don’t you realize that you guys, and you guys ...

How Can I Configure an Expiration Date for a Local User Account?

Hey, Scripting Guy! How can I configure an expiration date for a local user account?-- GW Hey, GW. You know, it’s amazing how quickly things change in the fast-paced world of system administration scripting. For example, in Monday’s column we announced that, as time allowed and whenever possible, the Scripting Guys would include a ...

How Can I Import an Excel Spreadsheet Into an Access Database?

Hey, Scripting Guy! How can I import an Excel spreadsheet into an Access database?-- IE Hey, IE. Wait! Don’t tell us; let us guess. Just a moment … we’re picking up the vibrations now … the sensation is getting stronger and more distinct … OK, got it: you’d like to know how to import an Excel spreadsheet into an Access database...

How Can I Save a Table in an Access Database as a Spreadsheet?

Hey, Scripting Guy! How can I save a table in an Access database as an Excel spreadsheet?-- OT Hey, OT. You know, we appreciate the question, but where were you last week, when we really needed you? The truth is, last week was excruciatingly dull, at least for two of the Scripting Guys. While Scripting Guy Jean Ross was busy battling ninja ...