Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 550
Default Automating Word from Excel

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
automating a control box in excel oa501 Excel Worksheet Functions 2 April 23rd 08 03:09 PM
Automating import of Word tables into Excel Han Excel Discussion (Misc queries) 0 January 18th 06 08:42 AM
Automating Excel mvpejp Excel Discussion (Misc queries) 0 November 22nd 05 07:33 PM
AUTOMATING JOB SHEETS IN EXCEL bobby smith New Users to Excel 2 June 17th 05 05:50 PM
Automating Excel from VB .NET Howard Kaikow Excel Programming 12 August 31st 03 02:56 AM


All times are GMT +1. The time now is 01:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"