Showing tag results for Microsoft Excel

Hey, Scripting Guy! How can I sort a row in an Excel spreadsheet?-- RF Hey, RF. You know, this is a tough question, but as a resident of the state of Washington the Scripting Guy who writes this column doesn’t shy away from a challenge. Therefore, he fully intends to address this matter … in the year 2013. In case you’re wondering about that, a ...

Hey, Scripting Guy! How can I remove the password when opening an Excel spreadsheet?-- JE Hey, JE. You know, it’s finally happened: after two-and-a-half years of writing this column we’ve finally run out of things to talk about. The “heartbeat sensor” that can tell you whether someone is hiding in the backseat of your car? We talked about that a...

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, wouldn’t you? Ar...

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 warri...

Hey, Scripting Guy! How can I use a blank row to separate rows of data in a Microsoft Excel spreadsheet?-- AR Hey, AR. You know, most people believe that the Scripting Guys all think alike, that we always agree on everything. That’s not true, though; instead, like any other team, we disagree from time-to-time. Sure, the team would be best-served...