Showing tag results for Office

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 is a tiny bit convoluted. Because of that, don’t feel bad if y...

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 can say is that we made a mistake, and we’re sorry. For som...

Hey, Scripting Guy! On May 3rd you showed us how to merge multiple files in Microsoft Word. I’d like to do that, but put a page break between each file.-- CE Hey, CE. You know, when we read your email our first thought was this: no way did we show people how to merge multiple files back on May 3rd 2005. That wasn’t because we didn’t think that t...

Hey, Scripting Guy! How can I add a hyperlink to an Excel spreadsheet?-- J B-N Hey, J B-N. To begin with, we’d like to point out that we’re well aware of all the recent media scandals involving such prestigious organizations as The New York Times. As you know, many of those scandals revolve around writers who didn’t actually do the work they cla...

Hey, Scripting Guy! How can I take the last line in a group of text files and paste that information into a Word document?-- JV Hey, JV. You know, one thing we try to do in this column is focus on practical system administration tasks. We’ll deviate from that focus every now and then, but for the most part we try to address questions we feel a l...