software

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

run program quot;C:\Program\Microsoft Office\Office10\excel.exe
C:\temp\template.xlt /nquot;

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
quot;Gallianoquot; gt; wrote in message
...
|I am trying to open a template through code. Something like:
|
| run program quot;C:\Program\Microsoft Office\Office10\excel.exe
| C:\temp\template.xlt /nquot;
|
| 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
quot;DDE-commandquot;?

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

DDEExecute chan_num, quot;[Workbooks.Add Template:=quot;quot;c:\temptemplate.xltquot;quot;]quot;

But that´s not working...
quot;Jim Rechquot; skrev:

gt; With each new Excel session template numbering starts over. I don't think
gt; you can change that.
gt;
gt; --
gt; Jim
gt; quot;Gallianoquot; gt; wrote in message
gt; ...
gt; |I am trying to open a template through code. Something like:
gt; |
gt; | run program quot;C:\Program\Microsoft Office\Office10\excel.exe
gt; | C:\temp\template.xlt /nquot;
gt; |
gt; | I want excel to open a worksheet called template1 from the template. Next
gt; | time I want it to open template2 and so on.... As it is now it keep
gt; opening
gt; | template1 so after a few tries I have a number of template1:s... No good
gt; | since I want to keep them apart....
gt; |
gt; |
gt;
gt;
gt;

Sorry but I don't know DDE..

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