Vba code to save document as pdf using document property text and rename folder.
Hello everyone!
I am using Word 2010 and I have a document with following document property:
Author: Michael Staicu
Title: R6435
Company: ASIG-1234-EXP
Comments: BAAR/MGD/15/RO/03339
Publish date: 12.02.2015
I want to make a macro that automatically modifies the text from given document property fields and does the following:
1. Rename the folder that contains the document as:
R6435_BAAR.MGD.15.RO.03339 Michael Staicu ASIG1234EXP - 12.02.2015
(replacing "/" character from comments propery with "." character and removing "-" character from Company property).
2. Saves my word file with the following name:
R6435_BAAR.MGD.15.RO.03339 Michael Staicu ASIG1234EXP
(replacing "/" character from comments propery with "." character and removing "-" character from Company property).
3. Saves my word file as a pdf with following name:
R6435_BAAR.MGD.15.RO.03339 ASIG1234EXP
(replacing "/" character from comments propery with "." character and removing "-" character from Company property).
Any response I will gratefully appreciate as it saves me from a lot of work
Thanks and I wish you a good day.
|