Hi,
I'm able to create a link in a document to open another document, a html doc
etc. In this way I can create a link to open an Excel spreadsheet.
Now my question is: is it possible to create a link to an Excel template, in
order to open/create a spreadsheet based on that template? (when I do insert
a link straight on to a xl template, Word opens the template itself)

Thanks for your suggestions

Henk

Hello-

If I understand correctly, in this case you _do not_ want to create a link.
You are looking for a new file to be created based on the template. (I am
assuming you only want the new workbook stored as an object in the doc and
not as a separate .xls file.)

When you InsertObjectCreate From File choose your Excel Template as
before, but don't put a check in the Link to File box.

HTH |:)

"hstijnen" wrote:

Hi,
I'm able to create a link in a document to open another document, a html doc
etc. In this way I can create a link to open an Excel spreadsheet.
Now my question is: is it possible to create a link to an Excel template, in
order to open/create a spreadsheet based on that template? (when I do insert
a link straight on to a xl template, Word opens the template itself)

Thanks for your suggestions

Henk

Hello, CyberTaz,
Indeed I want to create a separate .xls file. The case is that I want to do
some complicated calculations in xls and copy only the result to my Word doc.
I end up with two related documents.

"CyberTaz" wrote:

Hello-

If I understand correctly, in this case you _do not_ want to create a link.
You are looking for a new file to be created based on the template. (I am
assuming you only want the new workbook stored as an object in the doc and
not as a separate .xls file.)

When you InsertObjectCreate From File choose your Excel Template as
before, but don't put a check in the Link to File box.

HTH |:)

"hstijnen" wrote:

Hi,
I'm able to create a link in a document to open another document, a html doc
etc. In this way I can create a link to open an Excel spreadsheet.
Now my question is: is it possible to create a link to an Excel template, in
order to open/create a spreadsheet based on that template? (when I do insert
a link straight on to a xl template, Word opens the template itself)

Thanks for your suggestions

Henk

Then you have 2 options I can think of:

1) Create the new workbook in Excel using your template and then link to it
from your doc, or

2) create the embedded wks object in your doc as described in my earlier
reply and once you enter your content click back into the doc. Right-click
the wks object, choose Worksheet ObjectOpen, then use that window's Save As
command to create a wks file. (This does _not_, however, create an active
link to the new wks file. If you want to have an active link you'll have to
replace the embedded object... you can convert Linked to embedded but not
vice vesa).

Good Luck |:)


"hstijnen" wrote:

Hello, CyberTaz,
Indeed I want to create a separate .xls file. The case is that I want to do
some complicated calculations in xls and copy only the result to my Word doc.
I end up with two related documents.

"CyberTaz" wrote:

Hello-

If I understand correctly, in this case you _do not_ want to create a link.
You are looking for a new file to be created based on the template. (I am
assuming you only want the new workbook stored as an object in the doc and
not as a separate .xls file.)

When you InsertObjectCreate From File choose your Excel Template as
before, but don't put a check in the Link to File box.

HTH |:)

"hstijnen" wrote:

Hi,
I'm able to create a link in a document to open another document, a html doc
etc. In this way I can create a link to open an Excel spreadsheet.
Now my question is: is it possible to create a link to an Excel template, in
order to open/create a spreadsheet based on that template? (when I do insert
a link straight on to a xl template, Word opens the template itself)

Thanks for your suggestions

Henk