Opening an excel workbook from a template in Access VBA

Hi there.....this may be a doosie but i was wondering if anyone knew how to go about opening an excel document derived from an excel template through VBA code in my Access form. I understand whenevr you open a template a new workbook is created but have no idea how to handle the code.

Any insight would be helpful.

Thanks

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"