Opening an excel workbook from a template in Access VBA

[jig]

Hope this is what you want.

You need to reference the excel object in the access module references under tools.


dim oExcel as excel.application
set oExcel = new excel.application

oExcel.workbooks.Add Template:= _
"C:\Program Files\Microsoft Office\Templates\Format_Files.xlt"