Feasability of using VBA for project?

[eaywbmk]

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 Kaikow]

See the list of Word VBA books at

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

Start with Steve Roman's Writing Word Macros.

 

[hals_left]

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]

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

 

[Jonathan West]

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

 

[Anne Troy]

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