Open and Close Workbooks
 

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

Open and Close Workbooks
 

Hi Tontonan

Is it working OK if you use
UpdateLinks:=3

Instead of
UpdateLinks:=True


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Tontonan" wrote in message ...
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

Open and Close Workbooks
 

Hi Ron,

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

Regards Ben

"Ron de Bruin" wrote:

Hi Tontonan

Is it working OK if you use
UpdateLinks:=3

Instead of
UpdateLinks:=True


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Tontonan" wrote in message ...
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