Template opening

[Guest]

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....

 

[Jim Rech]

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

--
Jim
|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....
|
|

 

[Guest]

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:

 

[Jim Rech]

Sorry but I don't know DDE..

--
Jim
| 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
| > | > |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....
| > |
| > |
| >
| >
| >