marco for data transfer

hi folks
want to transfer some data located in Excel to a table in word by clicking the button.
to open the correct template is ok, afterwords have set a bookmark in the appropirate cell in the word table and now a can i move the pointer one cell further to fill data from the secend cell in Excel ? i'm confused about the correct method i should use. any help or ideas ?

regards tomy

Hi =?Utf-8?B?dG9teQ==?=,

want to transfer some data located in Excel to a table in word by clicking the button.
to open the correct template is ok, afterwords have set a bookmark in the appropirate cell in the word table and now a can i move the pointer one cell further to fill data from the secend cell in Excel ? i'm confused about the correct method i should use.

Best is to not move the "pointer" (cursor/insertion point), but to address the cells in the table directly. This is faster and more accurate.

Code example:
Dim tbl as Word.Table
Dim doc as Word.Document

Set doc = wordapp.Documents.Add("C:\test\test.dot")
Set tbl = doc.Tables(1)
tbl.Cells(1, 1).Range.Text = "text"

The first Cells index is the row index, the second the column index.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-)