Opening an excel workbook from a template in Access VBA

[Leroy_Brown]

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

[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"