Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Long Documents / December 2003

Tip: Looking for answers? Try searching our database.

Macro to clean-up Formatting

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Peter - 09 Dec 2003 18:48 GMT
I am working on a large document that had multiple authors and am left with
a formatting mess. There are numerous font styles used for normal text and
headers (e.g. Heading 1 has three font sizes etc).

Is there a macro out there that will search thru the document and set all
the normal text to a standard font size. Ideally it would work with headsers
and footers as well.

Thanks,

Peter
Peter - 09 Dec 2003 21:16 GMT
I have reposted this question in microsoft.public.word.vba.customizations
where I guess it should have been in the first place.

> I am working on a large document that had multiple authors and am left with
> a formatting mess. There are numerous font styles used for normal text and
[quoted text clipped - 7 lines]
>
> Peter
Suzanne S. Barnhill - 09 Dec 2003 22:02 GMT
Define the styles as you want them to be, then Ctrl+A, Ctrl+Q,
Ctrl+Spacebar.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Signature

Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://www.mvps.org/word
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.


> I am working on a large document that had multiple authors and am left with
> a formatting mess. There are numerous font styles used for normal text and
[quoted text clipped - 7 lines]
>
> Peter
Peter - 10 Dec 2003 03:30 GMT
Thanks. Much easier than I expected.

Peter

> Define the styles as you want them to be, then Ctrl+A, Ctrl+Q,
> Ctrl+Spacebar.
[quoted text clipped - 21 lines]
> >
> > Peter
ward - 10 Dec 2003 11:09 GMT
1) Assign shortcut keys to the styles you use most
frequently(e.g. body = CTRL-0, Heading1 = CTRL-1, Heading
2 = CTRL-2, etc.)

2) Swith to normal view

3) Define a 2 cm or so value for the "style area
width"(Tools-options-view-style area width). A column will
now appear in the normal view, telling you the style of
each paragraph

4) Using your shortcuts you should now be able to clean up
your formatting really quick.

regards
Ward

>-----Original Message-----
>I am working on a large document that had multiple authors and am left with
[quoted text clipped - 10 lines]
>
>.
Peter - 10 Dec 2003 19:37 GMT
Thanks.

> 1) Assign shortcut keys to the styles you use most
> frequently(e.g. body = CTRL-0, Heading1 = CTRL-1, Heading
[quoted text clipped - 31 lines]
> >
> >.
John A. Kunecke - 11 Dec 2003 09:34 GMT
Well the previously state "solution" really is just
another way of doing it manually.

I would advise creating a style sheet that contains a set
of styles that meet your needs, including styles that
should be the same, but hve different names in the
different documents merely requires that you create a
style by that name, that is based on the desired actual
style.

Then by simply opening the documents, ensuring that
the "update document styles" checkbox is checked
(..Tools...Templates and Addins...[in Word 2k anyway])
then close the document, then reopen it...

Should make Word do the work for you.

In fact the only things that will leave out are:
  1: unstylized items
  2: header/footer size
  3: document page and section formatting

As far as points 2 and 3 are concerned, creating a
document "fragment" with the desired page and section
formats, then cut and paste (I can make that a macro for
you, if you want) the document content (as well as the
header/footer content) is the only way to fix that level
of problem.

If you have a lot of unstylized content, go slap the
author...send me some samples and I'll write the macro
for you.

I have over 600 macros, of which about 40 fix similar
issues.

Let me know how I can help.
Peter - 17 Dec 2003 13:41 GMT
John,

Thanks for the offer to help. Do you have a website that I can get your
macros from?

Peter

> Well the previously state "solution" really is just
> another way of doing it manually.
[quoted text clipped - 33 lines]
>
> Let me know how I can help.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.