Saving Word Documents using a Macro

[Wafty Cranker]

Hi,

I have to process some 5,000 documents, and need to change their
filename at the same time.

All of the documents have a name in the header in the format:
Firstname Middlename (where it applies) Surname

I need to save the documents as:
Surname, Firstname Middlename.doc

I know how to change the directory they're saved to, and I've managed
to do everything else that needs doing. This is the only thing that's
stopping me from being able to run the macro.

I don't know what terms to actually search for to be able to find help
on this, so I'm trying here.

I've tried to create a function that will let me create the filename,
and then use that as the Save As option, but I can't get it to work, as
I can't reference the function in the SaveAs Filename:=" " It will
only save as what I put in the " "... I've tried using brackets, and
nothing, but no luck.

Any help would be greatly appreciated.

Many thanks,

Wafty

 

[FRUSTRATED TO THE BITTER END!!!]

I have done this particular thing once or twice, but I don't recall exactly
what I did to do it. But here is a "How To" site that might answer your
questions. It is where I found 95% of the answers to my questions.

Good Luck.

Rochell3

 

[Wafty Cranker]

Thanks for replying, but you've left out the URL.

Anyone else?

Wafty

 

[Beth Melton]

You may want to post this question in one of the Word VBA newsgroups
since that's where the macro folks hang out.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/