Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

macro for Office 2007

0 views
Skip to first unread message

jatman

unread,
Mar 28, 2008, 6:09:02 PM3/28/08
to
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

rog982001

unread,
Mar 28, 2008, 7:28:00 PM3/28/08
to
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!
--
Roger

Doug Robbins - Word MVP

unread,
Mar 29, 2008, 5:26:02 AM3/29/08
to
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

"jatman" <jat...@discussions.microsoft.com> wrote in message
news:2A841781-27B7-41EA...@microsoft.com...

Graham Mayor

unread,
Mar 29, 2008, 6:24:10 AM3/29/08
to
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

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

0 new messages