hi
use the workbook open event on the last file.
Private Sub Workbook_Open()
Workbooks.Open Filename:= _
"C:\Your\file\path\BEA U.S Flows & Stock 1980-2007.xls"
'if you want the first wb to be active then add this line
'windows("Duignan_US-ASIA_EU Trade & FDI Flows").activate
End Sub

regards
FSt1

"J.Mart" wrote:

Hi,
How do I start to write a macro in excel that automatically opens the file
"BEA U.S Flows & Stock 1980-2007" when the file "Duignan_US-ASIA_EU Trade &
FDI Flows" is opened?