• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 169
  • Last Modified:

Transferring data directly into a Word document using VB

I have a program which uses an Access database and I want to be able to "transfer" data from the database directly into the a new Word document after it has opened the program. I am fairly sure that this should be an easy thing to do and hopefully lots of you know the answer! Thanks in advance for all suggestions.

Cheers,

Colin.
0
cbitservices
Asked:
cbitservices
  • 5
  • 4
1 Solution
 
justinhemphillCommented:
You will need to use the Microsoft Word Object Library.  This is available as one of your references in VB.  Once you careate an instance of this, you will be able to create word documents.  This will give you the full functionality of Word itself.  You can record a macro in Word and then go back in and view it.  You can then use this code within VB to generate it.
0
 
cbitservicesAuthor Commented:
Where can I get information on using the library? Thanks,

Colin.
0
 
Richie_SimonettiIT OperationsCommented:
You need to add a reference to microsoft word library, declare variables from it and work with object model.

Just a little example

dim wapp as word.application
dim wdoc as word.document

sub test
set wappnew word.application
set wdoc=wapp.documents.open("c:\mydoc.doc")
wapp.visible=true
end sub

and working from it.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
cbitservicesAuthor Commented:
OK, I now understand that I can use Word object library, but it would be helpful if anyone could tell me where to get the information on how to use it! Thanks,

Colin.
0
 
cbitservicesAuthor Commented:
I have worked out some of the properties and methods but a reference would be handy; any ideas? Thanks,

Colin.
0
 
Richie_SimonettiIT OperationsCommented:
Well, what is your data?, where is saved? a recordeset?, directly from a table?
How do you want to populate word document?
0
 
cbitservicesAuthor Commented:
Hi Richie,

I have already got it working to place data into the document from the database, etc., however, what I would like to know is whether there is a "Reference" anywhere for the methods and properties of the Word object, so that I could use the various facilities of the object more efficiently. If you know of such a thing please let me know. Thanks.

Regards,

Colin.
P.S. I will accept your comment as an answer and will post this as another question, so you will earn more points if you can help further. Thanks.
0
 
cbitservicesAuthor Commented:
I need reference material on the Word object. I have posted another question for this.
0
 
Richie_SimonettiIT OperationsCommented:
you could see it at MSDN (on cd or microsoft site).
There is a bunch of resources at web. Just do a search in www.google.com with "word+com+visual+basic"
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now