View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
eholz1 eholz1 is offline
external usenet poster
 
Posts: 32
Default make a "selection" in a word document from a module in excel

Hello Group,

I am trying to add bookmarks and text to a word doc. I can add a
bookmark using code from Excel like this:

Set wdApp = CreateObject("Word.Application")
Set myDoc = wdApp.Documents.Add(Template:=strDocumentNamePath)
With wdApp
..Visible = True
..WindowState = wdWindowStateMinimize 'wdWindowStateMaximize
End With

With wrdDoc.Bookmarks
.Add Name:=bName, Range:=rng
.DefaultSorting = wdSortByName
.ShowHidden = False
End With

The way that works in a word module works fine in word, but not when I
try to do the same thing from excel. the word code is below:
'With ActiveDocument.Bookmarks
'.Add Range:=Selection.Range, Name:="TestBookMark"
'.DefaultSorting = wdSortByName
'.ShowHidden = False
'End With

The problem I am having is understanding how to acess/define the word
document property/method (whichever it is) "Selection.Range" or
Selection.xxx in the module in my excel code. I know that the
"Selection" is local to the word document, but do not understand how to
do a "selection" from my excel module.

any info will be greatly appreciated.

thanks

eholz1