Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel templates with GetObject/CreateObject
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel templates with GetObject/CreateObject
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. -- Charles Chickering "A good example is twice the value of good advice." "jille" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help Please: Run Excel based sub from Access using GetObject | Excel Programming | |||
Excel is opening templates as templates instead of as worksheets | Setting up and Configuration of Excel | |||
Controlling Reflection1 from Excel using getObject | Excel Programming | |||
Templates and CreateObject | Excel Programming | |||
Excel Getobject error | Excel Programming |