open file Excel from MSWord automatically

[massi]

hi, i would like to create a macro that whne a MSWord file is open
automatically opens an Excel file .

i have tried the following but it doesn't work. any idea? thanks in advance
Sub Open_Internet_File()

'Open the file
Workbooks.Open FileName:="N:\graphs.xls"
End Sub

 

[Doug Robbins - Word MVP]

See the article "Control Excel from Word" at:

http://www.word.mvps.org/FAQs/InterDev/ControlXLFromWord.htm


--
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

 

[massi]

hi Doug,
the macro works fine but i cannot set it in order to run automatically
whenever i open the word document.
rgds

 

[Doug Robbins - Word MVP]

If you want a macro to run when you open a document, it needs to be named
autoopen.

--
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

 

[massi]

thanks a lot!!!

If you want a macro to run when you open a document, it needs to be named
autoopen.

--
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