Open template automatically

[Yiling]

I'm doing a project on designin a template to help staff prepare the cash budget with excel. In order to make it easy to use, how can i have EXCEL open the template automatically when Excel is activated?

[anilsolipuram]

You have to use macro for this, you can paste this code in vba editor , "this workbook".

go to tools->macro->visual basic editor-> double click "this workbook" on the left , paste this code, save the excel , close it and open it. As soon as it is opened template will be opened, you have to change the path defined in the code.


Private Sub Workbook_Open()
Workbooks.Open Filename:="C:\My Documents\template.xls" 'define the template path
End Sub