{"id":65813,"date":"2007-01-03T17:23:00","date_gmt":"2007-01-03T17:23:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2007\/01\/03\/how-can-i-clear-all-the-formatting-from-a-microsoft-word-document\/"},"modified":"2007-01-03T17:23:00","modified_gmt":"2007-01-03T17:23:00","slug":"how-can-i-clear-all-the-formatting-from-a-microsoft-word-document","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/how-can-i-clear-all-the-formatting-from-a-microsoft-word-document\/","title":{"rendered":"How Can I Clear All the Formatting From a Microsoft Word Document?"},"content":{"rendered":"

\"Hey, \n

Hey, Scripting Guy! How can I clear all the formatting from a Microsoft Word document?

— TF<\/P>\"Spacer\"\"Hey,\"Script<\/A> \n

Hey, TF. After a much-deserved holiday hiatus we are back, with the first official Hey, Scripting Guy!<\/I> column for the year 2007. And yes, we know: technically we did<\/I> have a column yesterday<\/B><\/A>. 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. Because of that, we don\u2019t really consider it to be the first official column for the year 2007. If you looked at yesterday\u2019s column we ask that you forget everything you read there.<\/P>\n

And no, for most of you that won\u2019t<\/I> be much of a problem, will it?<\/P>\n

Seeing as how this is<\/I> the first official column for the year 2007, do we have plans to make today\u2019s 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. Therefore, instead of anything extra-special you\u2019re getting a simple little script that we scraped together at the last possible minute. Which, if nothing else, means that you don\u2019t have anything to worry about: Hey, Scripting Guy!<\/I> is still the same as it ever was!<\/P>\n\n<\/THEAD>\n\n\n
\n

Note<\/B>. Speaking of which, did anyone watch the Fiesta Bowl game between Boise State and Oklahoma? Holy smokes! The stupid \u201cBowl Championship Series\u201d aside, you simply have<\/I> to love college football.<\/P>\n

And yes, you do<\/I> have to love it. That\u2019s just the way it goes.<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n

<\/DIV>\n

Now, where were we? Ah, yes: a script that removes all the formatting from a Microsoft Word document:<\/P>

Set objWord = CreateObject(“Word.Application”)\nobjWord.Visible = True<\/p>\n
Set objDoc = objWord.Documents.Open(“C:\\Scripts\\Test.doc”)<\/p>\n
objDoc.Select<\/p>\n
Set objSelection = objWord.Selection\nobjSelection.ClearFormatting\n<\/PRE>\n
You can see why we chose this topic on our first day back to work: there really isn\u2019t much to this thing at all. We start off by creating an instance of the ever-popular Word.Application<\/B> object, then set the Visible<\/B> property to True; that gives us a running instance of Microsoft Word that we can see on screen. As soon as Word is up and running we then use the Open<\/B> method to open the document C:\\Scripts\\Test.doc:<\/P>
Set objDoc = objWord.Documents.Open(“C:\\Scripts\\Test.doc”)\n<\/PRE>\n
As you might expect, Test.doc is a document absolutely rife<\/I> with fancy formatting:<\/P>\"Microsoft \n

Remember, we did <\/I>say fancy formatting, not beautiful formatting.<\/P>\n
As it turns out, Microsoft Word includes a built-in command that enables you to remove all the formatting applied to the selected text. What does that mean for us? For one thing, that means that, in order to remove the formatting from the entire document we first need to select the entire document. That\u2019s something we can do by calling the Document<\/B> object\u2019s Select<\/B> method, which \u2013 when called without any additional parameters \u2013 selects the entire document:<\/P>
objDoc.Select\n<\/PRE>\n
After we\u2019ve selected all the text we just need to do two more things: create an instance of Word\u2019s Selection<\/B> object, then call that object\u2019s ClearFormatting<\/B> method. That requires just two additional lines of code:<\/P>
Set objSelection = objWord.Selection\nobjSelection.ClearFormatting\n<\/PRE>\n
So what\u2019s the net result? This<\/I> is the net result:<\/P>\"Microsoft \n

Not bad for the first day back, if we do say so ourselves.<\/P>\n
Speaking of the first day back, that\u2019s a good question: is the Scripting Guy who writes this column excited about coming back to work after three weeks of lounging around watching football and basketball? Let\u2019s put it this way: he\u2019s every bit as thrilled about and dedicated to his job as he was before he went on vacation.<\/P>\n
We\u2019ll let you figure out what that means. Like they say, we report; you decide.<\/P>
\n
\n\n\n\n
\"Top<\/A>Top of page<\/A><\/TD><\/TR><\/TBODY><\/TABLE><\/DIV><\/p>\n","protected":false},"excerpt":{"rendered":"
Hey, Scripting Guy! How can I clear all the formatting from a Microsoft Word document?— TF Hey, TF. After a much-deserved holiday hiatus we are back, with the first official Hey, Scripting Guy! column for the year 2007. And yes, we know: technically we did have a column yesterday. As it turns out, however, that […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[84,49,3,5],"class_list":["post-65813","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-microsoft-word","tag-office","tag-scripting-guy","tag-vbscript"],"acf":[],"blog_post_summary":"
Hey, Scripting Guy! How can I clear all the formatting from a Microsoft Word document?— TF Hey, TF. After a much-deserved holiday hiatus we are back, with the first official Hey, Scripting Guy! column for the year 2007. And yes, we know: technically we did have a column yesterday. As it turns out, however, that […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/65813","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=65813"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/65813\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=65813"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=65813"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=65813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}