Using Excel templates with GetObject/CreateObject

[Guest]

Hi,

I'm trying to create a file from an Excel template using either GetObject or
CreateObject. I've had success with these functions but not sure how to apply
it to a template. Currently it opens the template itself instead of creating
a new file. The template will be used by multiple users for their own data.

I had a thought that I might be able to achieve the same outcome by
'sharing' the file and then making it read-only?

Any suggestions would be appreciated.

Thx,
Jille

 

[Guest]

I'm not quite sure what you're doing but something like this should work:
Dim wb As Workbook
Set wb = Workbooks.Add "C:\MyTemplate.xlt"

This should create a new workbook using your template.