linking

[Curt]

excel is source when I build a word doc. how can I link or tie it to a cell
in excel so it stays with that cell when sorting.
Thanks

 

[Cindy M.]

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

excel is source when I build a word doc. how can I link or tie it to a cell
in excel so it stays with that cell when sorting.

Could you elaborate on your question, please? And include the version of
Office involved? I'm having real problems understanding what it is you want to
do...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
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

 

[Doug Robbins - Word MVP]

I think that all you did was stir it.

Please provide a more detailed explanation with an example of the data, etc.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Curt]

Got a blip in code now Got first problem cleared will insert code
Sub GetWordDocument()
Dim wordDoc As Word.Document
'
'Get the Word document object
'
Application.StatusBar = "Getting Word Document object..."
Set wordDoc = GetObject("Word 3x5.doc", "Word.doc")
Application.StatusBar = "Getting Word 3x5..."
MsgBox wordDoc.Name & " has " & wordDoc.Words.word3x5 & "words."
'
'We're done, so quit Word and release object variable
'
Application.StatusBar = "Shutting Down Word..."
wordDoc.Application.Quit
Set wordDoc = Nothing
Application.StatusBar = False

End Sub
Thanks to all for help