macro for Office 2007

J

jatman

good afternoon,

i'm using Office 2007 on Vista and would like to make a macro for a
template. the template uses building blocks (date calander and select from
drop down list) in multiple locations.

i would like the macro to save using the date that was selected from the
calander and the text that was entered into one of the fields (the person's
name.)

if this was in excel, i could do this because the file name could be
referenced via the cell values, i could save the file and email it and leave
the template intact. In word, i have no idea where to start...

any suggestions, hints or ideas?

thank you,

jat
 
R

rog982001

Sure, the Help Screen in MS Word. It's very short and to the point. The Macro
Recorder will write your VB code for you. But the VB code probably won't
solve all your problems. So, you will be back to programming. If it does,
great!
 
D

Doug Robbins - Word MVP

I would suggest that you use a userform and then you can build the filename
from the data entered into the relevant controls on the form.

See the article "How to create a Userform" at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
G

Graham Mayor

In addition to the previous suggestions, I take it this document is an
on-line form? On-line form fields have bookmark names and the content can be
repeated using REF fields or with macros to write the content to other form
fields - see http://gregmaxey.mvps.org/Repeating_Data.htm
If you want to pick dates from a calendar see
http://www.gmayor.com/popup_calendar.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top