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.
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.