Automating a process in Word

N

niallheavey

Hello,

I am very new to VBA and Macro's in General in word but want to try
learn a few things about it.

Here's what i'm trying to do:

I have a word document created as a company invoice,
I have a section for company name and a whole section with an embedded
Excel sheet for putting in the items on the invoice

What I want to try do (Not even sure if its possible or not) is some
of the following:

1. When the document is opened it'll immediately open up a dialogue
box asking for the customer name which it will then place in the
relevant location (This will have special font style, colour and size)
2. I then want to create a default save name for the file that will be
in a specific folder, and will have a file name based on the customer
name.
2. I also have some other things I want to try do with the excel part
but I think if I can get the 1st two things working 1st it'll be a
great start!

Is it possible to do this with VBA and if so how easy is it?

Can anyone give me some tips? Even some links to some good tutorial
sites would be great!

Thanks a million.
 
D

Doug Robbins - Word MVP

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

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

and the following pages of fellow MVP Greg Maxey's website :

http://gregmaxey.mvps.org/Create_and_employ_a_UserForm.htm

http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm

If that information is of use to you, please do consider contributing to the
maintenance of that website to ensure its continued availability.


--
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, originally posted via msnews.microsoft.com
 

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