#1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Curt Curt is offline
external usenet poster
 
Posts: 32
Default linking

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
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cindy M. Cindy M. is offline
external usenet poster
 
Posts: 2,416
Default linking

Hi ?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 :-)

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Curt Curt is offline
external usenet poster
 
Posts: 32
Default linking

I have a excel sheet 1 That has a heading description useing 2000. I want to
creat a word doc for this column. Have a mail merge 3X5 template that I want
to use. Want to tie the word doc to the row in excel. Each row will have a
different description document. Multiple entries in sheet 1. These arrive at
different times and will need to be sorted. Can the word doc have a idenifer
that will keep it with the row created in when sorting in excel. Hope i
cleared some of the mud.
Thanks for help


"Cindy M." wrote:

Hi ?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 :-)


  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default linking

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" wrote in message
news
I have a excel sheet 1 That has a heading description useing 2000. I want
to
creat a word doc for this column. Have a mail merge 3X5 template that I
want
to use. Want to tie the word doc to the row in excel. Each row will have a
different description document. Multiple entries in sheet 1. These arrive
at
different times and will need to be sorted. Can the word doc have a
idenifer
that will keep it with the row created in when sorting in excel. Hope i
cleared some of the mud.
Thanks for help


"Cindy M." wrote:

Hi ?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 :-)




  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Curt Curt is offline
external usenet poster
 
Posts: 32
Default linking

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


"Doug Robbins - Word MVP" wrote:

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" wrote in message
news
I have a excel sheet 1 That has a heading description useing 2000. I want
to
creat a word doc for this column. Have a mail merge 3X5 template that I
want
to use. Want to tie the word doc to the row in excel. Each row will have a
different description document. Multiple entries in sheet 1. These arrive
at
different times and will need to be sorted. Can the word doc have a
idenifer
that will keep it with the row created in when sorting in excel. Hope i
cleared some of the mud.
Thanks for help


"Cindy M." wrote:

Hi ?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 :-)







  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Curt Curt is offline
external usenet poster
 
Posts: 32
Default linking

got it to work thanks for reply

"Doug Robbins - Word MVP" wrote:

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" wrote in message
news
I have a excel sheet 1 That has a heading description useing 2000. I want
to
creat a word doc for this column. Have a mail merge 3X5 template that I
want
to use. Want to tie the word doc to the row in excel. Each row will have a
different description document. Multiple entries in sheet 1. These arrive
at
different times and will need to be sorted. Can the word doc have a
idenifer
that will keep it with the row created in when sorting in excel. Hope i
cleared some of the mud.
Thanks for help


"Cindy M." wrote:

Hi ?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 :-)





Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
linking even pages and linking odd pages Karel Roos Microsoft Word Help 3 October 16th 06 03:21 PM
linking even pages and linking odd pages Karel Roos Microsoft Word Help 1 October 13th 06 03:15 PM
File size is huge after linking many png files - Word 2003 (build 11.5604.6412) L Mehl Microsoft Word Help 4 July 21st 05 07:19 AM
Linking Excel and Word Docs Julie L Microsoft Word Help 1 April 13th 05 02:12 PM
How do I control the size of the image when linking to an Excel s. gzuko30 Microsoft Word Help 1 January 16th 05 08:51 PM


All times are GMT +1. The time now is 09:55 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"