I am trying to open a template through code. Something like:

run program "C:\Program\Microsoft Office\Office10\excel.exe
C:\temp\template.xlt /n"

I want excel to open a worksheet called template1 from the template. Next
time I want it to open template2 and so on.... As it is now it keep opening
template1 so after a few tries I have a number of template1:s... No good
since I want to keep them apart....

With each new Excel session template numbering starts over. I don't think
you can change that.

--
Jim
"Galliano" wrote in message
...
|I am trying to open a template through code. Something like:
|
| run program "C:\Program\Microsoft Office\Office10\excel.exe
| C:\temp\template.xlt /n"
|
| I want excel to open a worksheet called template1 from the template. Next
| time I want it to open template2 and so on.... As it is now it keep
opening
| template1 so after a few tries I have a number of template1:s... No good
| since I want to keep them apart....
|
|

Ok... thats´s fair... But is there anyway I can open a template with a
"DDE-command"?

I have tried to send in the same syntax as in vB:

DDEExecute chan_num, "[Workbooks.Add Template:=""c:\temptemplate.xlt""]"

But that´s not working...



"Jim Rech" skrev:

With each new Excel session template numbering starts over. I don't think
you can change that.

--
Jim
"Galliano" wrote in message
...
|I am trying to open a template through code. Something like:
|
| run program "C:\Program\Microsoft Office\Office10\excel.exe
| C:\temp\template.xlt /n"
|
| I want excel to open a worksheet called template1 from the template. Next
| time I want it to open template2 and so on.... As it is now it keep
opening
| template1 so after a few tries I have a number of template1:s... No good
| since I want to keep them apart....
|
|

Sorry but I don't know DDE..

--
Jim
"Galliano" wrote in message
...
| Ok... thats´s fair... But is there anyway I can open a template with a
| "DDE-command"?
|
| I have tried to send in the same syntax as in vB:
|
| DDEExecute chan_num, "[Workbooks.Add Template:=""c:\temptemplate.xlt""]"
|
| But that´s not working...
|
|
|
| "Jim Rech" skrev:
|
| With each new Excel session template numbering starts over. I don't
think
| you can change that.
|
| --
| Jim
| "Galliano" wrote in message
| ...
| |I am trying to open a template through code. Something like:
| |
| | run program "C:\Program\Microsoft Office\Office10\excel.exe
| | C:\temp\template.xlt /n"
| |
| | I want excel to open a worksheet called template1 from the template.
Next
| | time I want it to open template2 and so on.... As it is now it keep
| opening
| | template1 so after a few tries I have a number of template1:s... No
good
| | since I want to keep them apart....
| |
| |
|
|
|