Hi,



I'm currently making a VBA macro which sets the whole word document in a correct style. I only have problems fixing the separators of the captions.

The captions of the tables and the figures allready exist, I just need a macro which corrects all the captions to separators with periods.

I know it has something to do with:

With CaptionLabels("Figure")
.separator = wdSeparatorPeriod
.includeChapterNumber = true
End with

But how to acitivate this for all the captions?

Try adding:
ActiveDocument.Fields.Update
after your code.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi again,

it still doesnt work, tried a bunch of things, but the hyphen in the captions won't change to periods..

Thanks in advance

Can you attach a document to a post with some representative captions (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Here an example document.
I need the vba to change all the captions with the correct separators.
On the second page you find my macro

Attached Files

Example.docx (52.5 KB, 10 views)

Your original code works fine for me as part of a complete macro:
PS: I've deleted the new thread you've just started on the same topic. Please don't create multiple threads for a single issue!

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Oh yes, I see,
But it doesnt with this document?

Attached Files

Headings.docx (65.8 KB, 12 views)

I ran the code on your previous attachment and it was updated. The latest one has no captions to update...

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Yes, created the example for the forum, but saw when it runned it worked for me as well.

But it doesnt run on the other (or any other document)

Your other document has no captions! Furthermore, if you add one, it displays as Figure 1.1. Since you have no captions, but any that you add are already in the correct format, that's why the macro won't do anything.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I've been playing around with it a bit, and I know the problem

If you close the document en open it again, it doesn't work anymore.
On any new document where it is set as a caption it does.

What does it change to the caption?

Did you save the changes? unless you have some other macro etc that runs at open, there is no other reason I can see why the changes would not remain. Note that making these changes does not affect new documents.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Yes but it's a macro which must fix old documents.
So if the caption is inserted new in the document, it works, even if its inserted with a hyphen.

But if you save the document (with wrong caption) and than open it again, it wont work anymore.

Do you get wat I mean?

No, I don't get that. Can you attach a document on which you say it won't work anymore?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]