Open template automatically
 

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?


--
Yiling
------------------------------------------------------------------------
Yiling's Profile: http://www.excelforum.com/member.php...o&userid=24633
View this thread: http://www.excelforum.com/showthread...hreadid=382215

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


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=382215