Automatically Open a Linked Excel Workbook

[Harlequin007]

Guys

I'm sure there's a FAQ or post about this but couldn't find one.

I need to have a workbook execute (open) another (linked) workbook on the "BeforeOpen" event.

I just need some help with the syntax if possible...

----------------------------
Cogito Ergo Sum

http://www.discworks.co.uk

----------------------------

 

[Nelviticus]

A workbook doesn't have a 'BeforeOpen' event - when would it run? Excel can't even see the code until it has opened the workbook, by which time it's too late!

You could put the following in the 'Workbook_Open' event of your first workbook:

Workbooks.Open "ANALYSIS.XLS"

Replace "ANALYSIS.XLS" with the name (and path, if necessary) of the book you want to open. This will open it as soon as your first book opens.

Nelviticus

 

[PHV]

You may also take a look at the RefreshAll or OpenLinks methods of the Workbook object.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Harlequin007]

Thanks PHV.

Before Open eh...?

I think I'll file that under "Ideas to keep to yourself"

----------------------------
Cogito Ergo Sum

http://www.discworks.co.uk

----------------------------