Showing tag results for Office

Hey, Scripting Guy! How can I import a fixed-width data file into Microsoft Excel?-- RS Hey, RS. This column is being written on a Friday morning, and so far it’s been a very weird morning at that. For one thing, it’s not raining and – if you look closely – you can even see the sun. (It’s been awhile, but we’d recognize the sun anywhere.) Even w...

Hey, Scripting Guy! I am trying to use Windows PowerShell to look at files on my computer; what I want to do is get back a history (that is, the last time a document was accessed) for all the Microsoft Office files in a folder and its subfolders. However, I’m not having much luck. Any ideas would be appreciated.-- KM Hey, KM. We don’t know if yo...

Hey, Scripting Guy! I have a column of data in Microsoft Excel that is formatted as MYYYY (12008 = January 2008) and MMYYYY (122007 = December 2007). I need to split these values into month and year, but I can’t figure out how to do that. Any suggestions?-- DW Hey, DW. Well, it’s finally beginning to warm up here in Scripting Land, assuming you ...

Hey, Scripting Guy! I’m trying to write a script that does something with all the email messages in my Outlook Inbox. However, I need to sort those messages by the date they were received, and I can’t figure out how to do that. Can you help?-- SL Hey, SL. You know, no doubt a lot of you who read this column have thought, “The Scripting Guy who w...

Hey, Scripting Guy! In PowerPoint user information is stored under the Tools menu. I would like to know if there is a way to extract this data by using a script.-- TV Hey, TV. You know, you might find this hard to believe, but the Scripting Guy who writes this column hardly ever loses anything; in fact, he’s actually pretty good about putting th...