excel and word interaction

Hi,

what I'd like to do is this:

having an sheet in excel with a link to one word document each which are templates. After the templates are filled out and saved the name of the saved file should be included into the excel sheet as a link to it.

It's like this:

- open excel template
- click link to Word template in excel sheet
- fill out word template and save file
- save excel sheet with link to the just saved file

Any help would be highly apreciated.

Thanks.

Hi,

what I'd like to do is this:

having an sheet in excel with a link to one word document each which are templates. After the templates are filled out and saved the name of the saved file should be included into the excel sheet as a link to it.

It's like this:

- open excel template
- click link to Word template in excel sheet
- fill out word template and save file
- save excel sheet with link to the just saved file

Any help would be highly apreciated.

Thanks.

i wonder what you mean with link perhaps something like weblinks? dont now if this is working
but you can open the worddoc with a commandbutton you place in the excelsheet the code can i give you later if you want

then i think you need a textbox in your worddoc in which you place the name it will be saved(i.e. if you had to fill in your name into the template you can use this as savename)
then excel can grab the value of this textbox and create a new cmdbutton(or if it works a new link) in your sheet

i dont know if its the easiest way but it possibly works

i wonder what you mean with link perhaps something like weblinks? dont now if this is working
but you can open the worddoc with a commandbutton you place in the excelsheet the code can i give you later if you want

then i think you need a textbox in your worddoc in which you place the name it will be saved(i.e. if you had to fill in your name into the template you can use this as savename)
then excel can grab the value of this textbox and create a new cmdbutton(or if it works a new link) in your sheet

i dont know if its the easiest way but it possibly works

I mean a hyperlink but to a localy saved word template. It works fine in Excel to open the template but since I am not at all into VB everything but that is a bit much.

I'd be happy if you could provide me with the correct code for the text box (since some text from the template will not work) and the piece of code for the hyperlink back in Excel.

Thanks a lot,
Thomas

sorry
i havent found it yet,
but if someone else read this we need the code for a textbox in word that transfers its value to an textbox in excel
can anybody help??? please

try this format:
=HYPERLINK("C:\XXX\WORD.DOT","Hey This Is What the User Will See"

its correct but its only the first step
with this you get to the word template
but this was the minor problem

the problem in question is
how can i say excel:
create a link to the just saved word file

I don't know much about Word but,
If you know how to send information from Word to Excel
(maybe through the clipboard ?)
then you could get the Word template path like this :

Private Sub CommandButton1_Click()
Dim p As String, n As String

p = ThisDocument.Path
n = ThisDocument.Name

MsgBox p & "\" & n
End Sub

If you then could get p & n into the hyperlink the rest would be easy

Sub Macro2()

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"C:\Documents and Settings\Eigenaar\Mijn Documenten\Doc1.Doc", ScreenTip:= _
"Go to Doc1 test", TextToDisplay:="Doc1 test"
End Sub

Where "Anchor" is the cell where you want to put in the Hyperlink,
"Address" the path of the document (this could be p & "\" & n),
"Screentip" the text displayed when you move over the Hyperlink and
"TextToDisplay" the Hyperlink text displayed in the cell.

I have done that for my job... Very nice automation... In Excel, I click on a Button... then I select an output file... then Excel opens up Word and add to it a document... then it transfers the data into a table creates Bookmarks and Fields liked to them... then it save the document...

Tell me where you are in the developpement of yours and I will guide you...

YX