put the following code into the ThisWorkbook file that is on the left hand side in VBA with the little excel icon.

Sub Workbook_Open()

Workbooks("sample.xls").Activate
ActiveWorkbook.Close
Workbooks.Open Filename:="c:\sample.xls"

End Sub