Remember, we did say fancy formatting, not beautiful formatting.Īs it turns out, Microsoft Word includes a built-in command that enables you to remove all the formatting applied to the selected text. As soon as Word is up and running we then use the Open method to open the document C:\Scripts\Test.doc: Set objDoc = (“C:\Scripts\Test.doc”)Īs you might expect, Test.doc is a document absolutely rife with fancy formatting: We start off by creating an instance of the ever-popular Word.Application object, then set the Visible property to True that gives us a running instance of Microsoft Word that we can see on screen. You can see why we chose this topic on our first day back to work: there really isn’t much to this thing at all. Now, where were we? Ah, yes: a script that removes all the formatting from a Microsoft Word document: Set objWord = CreateObject(“Word.Application”) Speaking of which, did anyone watch the Fiesta Bowl game between Boise State and Oklahoma? Holy smokes! The stupid “Bowl Championship Series” aside, you simply have to love college football.Īnd yes, you do have to love it. Which, if nothing else, means that you don’t have anything to worry about: Hey, Scripting Guy! is still the same as it ever was! Therefore, instead of anything extra-special you’re getting a simple little script that we scraped together at the last possible minute. Seeing as how this is the first official column for the year 2007, do we have plans to make today’s article extra-special and worthwhile? You bet we do unfortunately, though, none of the other Scripting Guys wrote an extra-special, worthwhile article while the Scripting Guy who writes this column was away. If you looked at yesterday’s column we ask that you forget everything you read there.Īnd no, for most of you that won’t be much of a problem, will it? Because of that, we don’t really consider it to be the first official column for the year 2007. As it turns out, however, that column was actually written a few weeks ago, before the Scripting Guy who writes this column left on vacation. And yes, we know: technically we did have a column yesterday. After a much-deserved holiday hiatus we are back, with the first official Hey, Scripting Guy! column for the year 2007. you could also loop through each cell to prevent Excel from freezing.Hey, Scripting Guy! How can I clear all the formatting from a Microsoft Word document? If you are working with an extremely large range in a large Workbook, Excel could potentially freeze. If you’d like to clear the formatting of an entire worksheet, use the Cells Object instead: Sub ClearSheetFormats() This will clear Cell Formatting for Range A1:C1. Note: Instead, if you’d like to clear everything about the cell use. You can clear cell formatting by using the ClearFormats method of the Range Object. This tutorial will demonstrate how to clear the formatting of a cell or entire range of cells.
0 kommentar(er)
