macro for Office 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jatman - 28 Mar 2008 23:09 GMT

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

Reply to this Message

rog982001 - 29 Mar 2008 00:28 GMT

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!

Signature

Roger

> good afternoon,
>
[quoted text clipped - 15 lines]
>
> jat

Reply to this Message

Doug Robbins - Word MVP - 29 Mar 2008 10:26 GMT

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

Signature

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

> good afternoon,
>
[quoted text clipped - 18 lines]
>
> jat

Reply to this Message

Graham Mayor - 29 Mar 2008 11:24 GMT

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

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> good afternoon,
>
[quoted text clipped - 16 lines]
>
> jat

Reply to this Message