Open Working Copy of Excel Template... 2

[MeisoT]

I need to open a working copy (.xls) of an Excel Template (.xlt). Using the RunApp command in a macro opens the actual template file, but not a working .xls copy.

I've seen previous posts for this topic, but no suitable answer. Anyone have any idea how to do this?

Thanks,
EJ

 

[crobg]

Use:

Workbooks.Add [i]Template[/i]

 

[MeisoT]

Thanks crobg, but I forgot to mention that I am opening the template from within Access using a macro - not from within Excel. How can I open it from Access?

 

[crobg]

I thought you might want to do this from Access but I wasn't sure.

Make sure you have Microsoft Excel checked in your reference list. (From a module, go to menu Tools->References.)

Dim xl As New Excel.Application

Set xl = CreateObject("Excel.Application")
xl.Visible = True
xl.workbooks.Add "c:\test.xlt"

 

[crobg]

I'm sorry, that last post is for a module not a macro. This is the easiest way I know to do what you are looking for. Copy the following code into a module and then you can call it from any event in Access. Including a Macro by using RunCode command.

Function OpenTemplate()
Dim xl As New Excel.Application

Set xl = CreateObject("Excel.Application")
xl.Visible = True
xl.workbooks.Add "c:\test.xlt"
End Function

 

[MeisoT]

crobg, you are a genius. It works great!!! I've seen other posts with the same question but this is the first correct response I've seen. Thanks a million!