[RESOLVED] Open XLT through Word

[Kubull]

Hey all,

Sorry if this is a daft question, I need to link a Excel template (xlt) into a form in word. We use Word as our main conduite to all things (databases, Word Templates, powerpoint slides etc.. through our normal.dot)

At the moment my code opens the xlt directly, I tried using 'Newtemplate:=False' but that came up with "RT error 448 named argument not found"

Not sure what to try next, can't seem to think of the right context.

Any help would be greatly appriciated

Sub DLSStructure()
MyappID = Shell("C:\Program Files\Microsoft Office\Office\excel.exe", 1)  ' Run Microsoft Excel.
FileSystem.ChDir "K:\" 'Changes the current directory.
Set xl = CreateObject("Excel.Sheet") 'Creates a reference to Excel
xl.Application.Workbooks.Open "K:\Noticeboard\DLS structure\DLS Structure.xlt", NewTemplate:=False 'Opens workbook"
Exit Sub
End Sub

[Kubull]

Found it... Thanks anyways..

in the end all I needed was some food (Fual for the brain)

I recoded the Line - From

xl.Application.Workbooks.Open _
"K:\Noticeboard\DLS structure\DLS Structure.xlt" 'Opens workbook"

To:

xl.Application.Workbooks.Add Template:= _
"K:\Noticeboard\DLS structure\DLS Structure.xlt" 'Opens workbook"