Transferring data from xl to word(header)

aadarsh · Jun 10th 2005

Hi

I have a word template into which i need to feed data, which is filled by users into an excel userform...i know the obvious quest why excel..well the data is used for doing other stuff also..

But this is where i am getting stuck, i need to insert selected data from the userform to the header of the attached word template file.
All the places marked in red is where text from the userform goes

I need to know if there is a way to write an excel VBA code to do this

Aadarsh

Dreamboat · Jun 17th 2005

Re: Transferring data from xl to word(header)

So sorry you never got a response. Best bet... try bookmarks.

You can populate bookmarks.

Start here: http://www.vbaexpress.com/kb/getarticle.php?kb_id=381

Alternative: Use the properties to create fields in the header. Then populate the properties of the document using Excel VBA.

aadarsh · Jun 17th 2005

Re: Transferring data from xl to word(header)

Hi..Thats what i dd abt a week ago ago and worjks fine now

Thanx neways

Aadarsh

**norie** · Jun 17th 2005

Re: Transferring data from xl to word(header)

Can you not just use Mail Merge with the Excel spreadsheet as the data source?

Transferring data from xl to word(header)

Participate now!

Share