Automating Word from Excel

J

John Wilson

Having a dilemma here trying to add some text to an existing Word document.

I can use a bookmark and get my text into the document with a
Dim wordRange As Object
wordRange.InsertAfter

The problem with the above is that it "inserts" as opposed to "overwrite"
and
shifts all my other text and lines.

I've tried setting .Overtype to True and still no luck.

So my next adventure was to create a textbox via the controls toolbox
positioned
where I needed it and populate it from Excel but I can't determine how to
access
the textbox from Excel.

Anyone have any ideas on how I can do this or maybe another workaround?

Thanx,
John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top