Wrox Programmer Forums
|
Word VBA Discuss using VBA to program Word.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Word VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 22nd, 2009, 04:17 AM
Registered User
 
Join Date: May 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy Need help in word VBA

Hello Everyone,

I am new in word VBA and need help with below thing:-

I am into a job where I receive word documents from customers with questions in it regarding our services and products. Many a times I receive a template which has almost the same questions I already have answered into the previous word doc to previous customer.

In this scenario I want to make such a code that once I come across a question which I have already answered in previous template I trigger the code and it searches for the question of the current doc into the previously answered document (which is also open on my system) and once it finds it copies the answer to it, comes back to the current document and paste it right below the question.


Please let me know if that's possible and if yes how to do the codes..
I have been doing Excel VBA codes but have not a little idea about word coding.

Thanks in advance :)>

Regards,
Premanshu.
 
Old May 22nd, 2009, 08:31 AM
Friend of Wrox
 
Join Date: Sep 2005
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

First let me appreciate for your thoughts. The concept is widely called as KADB - Known Answer Database and mosty will be in some RDBMS

IF you are very much particular about the formatting, you can have it as a Word table - Column 1 containing the question and Column 2 the answer.

You can use Selection.Find to search for the question in column 1 and grab the answer from column 2

Give it a try

Cheers
Shasur
__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)
 
Old June 25th, 2009, 09:46 AM
Registered User
 
Join Date: Jun 2009
Posts: 1
Thanks: 1
Thanked 0 Times in 0 Posts
Default how to post a new question

I am new for this forum. I tried to post a new question, and am unable to know how do I post it? Can you help me? thanks.
 
Old June 26th, 2009, 10:04 PM
Friend of Wrox
 
Join Date: Sep 2005
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

On top of every forum you have a button called New Thread. You can use this to create new posts

Cheers
Shasur
__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)
The Following User Says Thank You to Shasur For This Useful Post:
francoboiti (June 27th, 2009)





Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel to Word VBA genericcereal Word VBA 1 May 11th, 2009 08:25 PM
is there a folder for vba word? muki Excel VBA 3 November 18th, 2005 05:46 AM
vba and MS Word Earl G. Hyde VB How-To 0 December 27th, 2003 02:06 AM
Word VBA sdowen Excel VBA 4 December 3rd, 2003 04:32 PM
VBA Word gcookie79 Excel VBA 1 November 12th, 2003 01:04 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.