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