Showing results for Office - Scripting Blog [archived]

Hey, Scripting Guy! How can I tell if a specific Excel workbook is open and, if it isn’t, open it?-- RK Hey, RK. Every now and then we see a question and think, “We should answer this one; it’s so easy it won’t take more than a few minutes to finish the column and then we can all take a nice long lunch.” At some point you’d think we’d learn that...

Hey, Scripting Guy! How can I insert a column into an Excel spreadsheet?-- HE Hey, HE. Let’s assume you have a spreadsheet that looks something like this: And, yes, it is a very nice little spreadsheet, except for one problem. As you can see, we goofed, and we forgot to insert Dataset 3; instead, we only have Datasets 1, 2, and 4. Even worse, D...

Hey, Scripting Guy! I have a folder of about 1,000 .RTF files. I need to convert all of these to Word documents (.DOC files). Can you help me with this?-- LS Hey, LS. Sure, we can help you. We’re not going to, but we could if we wanted to. No, wait, come back: we’re just kidding. Not only can we help you, but we will help you. To prove it, let’s...

Hey, Scripting Guy! I’d like to copy one of the worksheets in an Excel workbook and then paste that copy into the very same workbook; once it’s pasted it, I’d like to rename it. Can I do that?-- JG Hey, JG. Of course you can do this; after all, if you can do something in Excel it’s almost 100% guaranteed that you can do it using a script. This i...

Hey, Scripting Guy! I’d like to be able to open an Excel spreadsheet, get all the information off one of the worksheets, and then save that worksheet data to a comma-separated values file. How can I do that?-- SS Hey, SS. You know, you just have to love Excel. Yes, we know, to be “cool” these days you’re supposed to say th...