Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / October 2005

Tip: Looking for answers? Try searching our database.

Open Excel when a Word doc is opened

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Arts Lost - 05 Oct 2005 16:28 GMT
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 - 05 Oct 2005 20:18 GMT
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
Signature

"Who will guard the guards?"

> 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.