Feasability of using VBA for project?

Hi!

I have been asked to produce a solution for a business. At present I
have limited knowledge of VBA and macros. I was wondering if someone
might be able to advise me whether what I'm wanting to achieve is
possible and perhaps direct me to the best sources of information?

Is it possible:

1. For a form to appear in Word, user chooses options, then
pages/tables/text can be inserted into the current document from other
word documents according to what the user has chosen?

2. To have validation checks on word VBA forms?

3. For command buttons to exist on word documents (eg, to launch forms)
which don't show up when printed?


Would info on how to achieve this be possible to find on the internet
or would I need to invest in an appropriate book on the subject?


Any advise much appreciated,
Ben

Howard
Fri Jun 24 07:13:28 CDT 2005

See the list of Word VBA books at

http://www.standards.com/index.html?WordVBABooks

Start with Steve Roman's Writing Word Macros.

--
http://www.standards.com/; See Howard Kaikow's web site.
<eaywbmk@nottingham.ac.uk> wrote in message
news:1119606903.444991.247440@g44g2000cwa.googlegroups.com...
> Hi!
>
> I have been asked to produce a solution for a business. At present I
> have limited knowledge of VBA and macros. I was wondering if someone
> might be able to advise me whether what I'm wanting to achieve is
> possible and perhaps direct me to the best sources of information?
>
> Is it possible:
>
> 1. For a form to appear in Word, user chooses options, then
> pages/tables/text can be inserted into the current document from other
> word documents according to what the user has chosen?
>
> 2. To have validation checks on word VBA forms?
>
> 3. For command buttons to exist on word documents (eg, to launch forms)
> which don't show up when printed?
>
>
> Would info on how to achieve this be possible to find on the internet
> or would I need to invest in an appropriate book on the subject?
>
>
> Any advise much appreciated,
> Ben
>

hals_left
Fri Jun 24 07:20:14 CDT 2005

Hi Ben,
I think you need to ask other questions if this is for a commercial
project, not just development, deployment, integration and maintenance
of the solution.

hals_left
Fri Jun 24 07:20:45 CDT 2005

Hi Ben,
I think you need to ask other questions if this is for a commercial
project, not just development but deployment, integration and
maintenance of the solution in the target environment.

hals_left

Anne
Fri Jun 24 07:30:10 CDT 2005

Hi, Ben. You might want to consider joining www.vbaexpress.com. Also, I have
around here somewhere a sample file that shows exactly your #1. I'm pretty
sure there's a #2 (but perhaps for Excel?, but certainly a place to start)
for your #2. For #3, no. You want to build toolbars using VBA, don't mess
with command buttons on your document. Here's a specific sample for that:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=14
I'm not a book person. I have many VBA books, and still can't learn it. So I
created VBAX. LOL! Now I get just about all the free code and code help I
could want.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


<eaywbmk@nottingham.ac.uk> wrote in message
news:1119606903.444991.247440@g44g2000cwa.googlegroups.com...
> Hi!
>
> I have been asked to produce a solution for a business. At present I
> have limited knowledge of VBA and macros. I was wondering if someone
> might be able to advise me whether what I'm wanting to achieve is
> possible and perhaps direct me to the best sources of information?
>
> Is it possible:
>
> 1. For a form to appear in Word, user chooses options, then
> pages/tables/text can be inserted into the current document from other
> word documents according to what the user has chosen?
>
> 2. To have validation checks on word VBA forms?
>
> 3. For command buttons to exist on word documents (eg, to launch forms)
> which don't show up when printed?
>
>
> Would info on how to achieve this be possible to find on the internet
> or would I need to invest in an appropriate book on the subject?
>
>
> Any advise much appreciated,
> Ben
>

Jonathan
Fri Jun 24 07:26:57 CDT 2005


<eaywbmk@nottingham.ac.uk> wrote in message
news:1119606903.444991.247440@g44g2000cwa.googlegroups.com...
> Hi!
>
> I have been asked to produce a solution for a business. At present I
> have limited knowledge of VBA and macros. I was wondering if someone
> might be able to advise me whether what I'm wanting to achieve is
> possible and perhaps direct me to the best sources of information?
>
> Is it possible:
>
> 1. For a form to appear in Word, user chooses options, then
> pages/tables/text can be inserted into the current document from other
> word documents according to what the user has chosen?

Yes. Take a look at this article

How to create a Userform
http://www.word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

>
> 2. To have validation checks on word VBA forms?

Yes.

>
> 3. For command buttons to exist on word documents (eg, to launch forms)
> which don't show up when printed?

Yes. Take a look at this article

How to hide a Print commandbutton on a document form when a user clicks on
it
http://www.word.mvps.org/FAQs/TblsFldsFms/HidePrintButton.htm

>
>
> Would info on how to achieve this be possible to find on the internet
> or would I need to invest in an appropriate book on the subject?

If you are not familiar with VBA, this is a quite a big project to take on
as a starter. You can find lots of information at http://word.mvps.org and
in the books that others have recommended.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org