move to a unique point in Word document from excel

Hi all,

I am trying to write a script to copy something from Excel, switch to a Word file, search for a unique bit of text such as "paste_here" and then overwrite that text with the pasted data from excel.

The data to be copied can be either the cell or the value, I don't mind.

Can someone help me?

At the moment I have this for the copy/paste but I need to move the cursor to the "paste_here" bit.

Please Login or Register  to view this content.

I was thinking about using a Find (and/or replace), which usually moves the cursor, but I cannot get that to work. Any help?

Thanks.

The only way I know is to use bookmarks. Then use the following to move your selection to the desired bookmark.

Please Login or Register  to view this content.