Open and Close Workbooks

T

Tontonan

I have a workbook called TMU 501.xls that is linked to another work book
called Member Lists.xls Workbook TMU 501 has drop down lists. These lists
get the info from the work book called Member Lists.xls

When I open TMU 501.xls, Member Lists.xls is opened automatically using the
code below.

Private Sub Workbook_Open()
Workbooks.Open "D:\My Documents\Ben\Work\Practice\Members List.XLS",
UpdateLinks:=True
ThisWorkbook.Activate
Sheets("TMU 501").Select
Range("F3").Select
End Sub

I have 2 questions:-

1. Is the code below correct for opening a linked work book as it seems to
work Ok in Excel 2007, but in Excel 2003 the update links message always
appears.

2. Is there any way to close Member Lists.xls automatically when I close TMU
501.xls


Thank you
 
R

Ron de Bruin

Hi Tontonan

Is it working OK if you use
UpdateLinks:=3

Instead of
UpdateLinks:=True
 
T

Tontonan

Hi Ron,

Thank you for the reply, unfortunately it does not fix the problem.

Regards Ben
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top