Open template automatically

  • Thread starter Thread starter Yiling
  • Start date Start date
Y

Yiling

I'm doing a project on designin a template to help staff prepare th
cash budget with excel. In order to make it easy to use, how can i hav
EXCEL open the template automatically when Excel is activated
 
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
 
Back
Top