Open Excel when a Word doc is opened

[Arts Lost]

New to this VBA... is there a way to have Excel load and open a worksheet
automatically when I open a specific Word document?

Thanks for any guidance...

Lost in Juarez

 

[Anand.V.V.N]

Hi,

You want the document to open excel in word or in a sperate window?

Though I am not sure how to open the excel file in a seprate window as in as
excel application

In the the path of the excel file dosn't change, you can record a macro that
opens the excel file.

In case you want to open as a seprate applicaiton,Open the visual basic
editor and write the code in the document open event

Try this code it might work

Excel.Application.Visible = True
Excel.Application.Workbooks.Open FileName:= 'Put the file path and name here

I hope you find this useful.

Anand