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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks