Opening Template
Hello Jake,
Well I had asked about .dot but anyway the Idea works even in that Thanks
SSR
"Jake Marx" wrote in message
...
Hi SSR,
You should use the Add method of the Workbooks collection to create a new
Workbook based on a template. For example:
Dim xlApp As Excel.Application
Dim xlWB As Excel.Workbook
Set xlApp = New Excel.Application
Set xlWB = xlApp.Workbooks.Add("mytemplate.xlt")
MsgBox xlWB.Name
xlWB.Close False
Set xlWB = Nothing
xlApp.Quit
Set xlApp = Nothing
Regards,
Jake Marx
MS MVP - Excel
"Srinath" wrote in message
...
Hello,
When an Word Template is Opened by Double clicking in the explorer window
it
creates a .doc File which is then to be saved . How can this be acheived
if
I use Automation through Excel. I am Able to open the Template but it
opens
the .dot file and not the .doc file without name
Regards
SSR
|