exporting userform data to document

**mania112** · 10-27-2009, 10:16 AM

i'm fairly new to VB and i've never used it in Word, only Excel.

i've created a couple of userforms for users to automate the generation of a report for a client.

question is how do i reference something in a document so the code knows where to enter the data.

previously in excel, it's easy enough to reference a cell, not sure how you do this in word.

if you could show me an example, i'd be very grateful

**Andy Pope** · 10-28-2009, 07:05 AM

In Word you can use bookmarks.

**mania112** · 10-28-2009, 08:26 AM

do you have an example of bookmarks in action?

in your experience do you think is the best method for report writing. these reports are maybe 80% the same each time, but there are portions that need to be inputted, obviously client name and age for example.

a second option (other than userforms) would be to lock the document and have text box's that the user can tab to, i think this could be a fairly quick alternative to userforms.

**Andy Pope** · 10-28-2009, 08:49 AM

Word documents have FormFields designed exactly for this. Basically inline text areas.

http://www.dailydoseofexcel.com/arch...tomating-word/

http://word.mvps.org/FAQs/TblsFldsFms/index.htm

**mania112** · 10-28-2009, 09:39 AM

are you talking about the 'controls' options in the developer tab?

i can't see form fields per se, but i think these are the same things (in Office 07)

looks like this is the way forward.

are there form fields (or something similar) for creating tables? the only bespoke feature is that we will have a couple of tables that can vary in size.

**Andy Pope** · 10-28-2009, 10:14 AM

Yes, in wd2000, on the developer tab, In the controls group.
Either the new controls or the legacy ones.

Once set up you can protect the document so only formfields can be accessed.

Probably not a whole table in 1 go though.

**mania112** · 10-28-2009, 11:51 AM

not sure how i'm going to arrange the tables. is there anyway to unprotect just tables or objects?

thanks for the help!

**Andy Pope** · 10-28-2009, 12:15 PM

I don't use or know Word well enough to tell you. Others maybe able to offer advice.

You may find it will help those trying to help you if you posted an example of what you are trying do to.

**mania112** · 10-29-2009, 10:31 AM

if there are any Word specialists that can help with the above, i'd be very grateful.

i'm also looking into the possibility of using ask and if fields?