Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to link doc to Excel template?
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP-failure initiating DDE link with MS excel during word mail me | Mailmerge | |||
HELP-failure initiating DDE link with MS excel | Mailmerge | |||
HELP-failure initiating DDE link with MS excel | Mailmerge | |||
Extra space when pasting link from excel to word as unformatted te | Microsoft Word Help | |||
Excel Link: Adding rows in Excel does not add cells in Word | Tables |