GetObject & CreateObject

[jille]

Hi,

I'm trying to access an Excel file from Word. I can use both GetObject &
CreateOjbect successfully, but the file I want to open is a template, and
instead of actually opening the template, I want to create a file from the
template because the file will be used by multiple users for separate data
sets.

Could I achieve the same outcome by 'sharing' the file and then making it
read-only? Fyi, most users are using Word/Excel 2000.

Any ideas?

Thanks,
Jille

 

[Jezebel]

Set xlApp = Excel.Application
Set xlBook = xlApp.Workbooks.Add(Template:="...")