View Single Post
 
Old 10-28-2014, 12:40 PM
DefinedDesign DefinedDesign is offline Windows 7 32bit Office 2013
Novice
 
Join Date: Oct 2014
Posts: 5
DefinedDesign is on a distinguished road
Default Save As PDF Macro/VBA with Predetermined File Name

Hello

I am adding a control button to a form template in Word 2013 and I need to write a macro/vba that will save the form as a PDF with a predetermined name, along with the name from the formfield, and date.

I would basically like the predetermined part of the file name to read:

NURS_353_Clinical_Evaluation_

Then I want to add the student's name from the formfield in the document:

NURS_353_Clinical_Evaluation_Jane_Doe_

Then add the date the file is being saved to give a complete file name of:

NURS_353_Clinical_Evaluation_Jane_Doe_10.28.2014

I need the user of the form to be able to save this PDF file anywhere on their computer or network without losing the file name.

I found a couple Macro's on the web, and tried to use them but they don't meet my needs. I confess I'm a complete newbie to all this macro/vba stuff.

Thanks in advanced for your advice!
Reply With Quote