Hi, I am struggling with what I thought would be a simple task: calling a sub from another workbook.

When I open a workbook I want it to call the DisplayBriefDetails sub of the spreadsheet "Ad Master2.xls". I have tried the below code and many other alternatives (such as adding a reference to Ad Master2) but I cannot get it to work. Any help would be appreciated.

Private Sub Workbook_Open()
   Workbooks.Open "\\scsrv-03\mktgdata$\Adcopy\Ad Master2.xls"
   Workbooks("Ad Master2.xls").DisplayBriefDetails
   Workbooks("Ad Master2.xls").Close
End Sub