Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Insert another file into an open document
Insert another file into an open document
1. Click where you want to insert the second document. 2. On the Insert menu, click Insert File. 3. To insert only part of a Microsoft Excel worksheet, click Range, and then type a cell range in the Range box. PROBLEM I am having a problem with step 3 above. After I type a cell range(e.g. B2, or e.g. A1:B3) into the range box then select insert, a File Conversion dialogue box appears. So at this point, Word is having difficulty in inserting excel cells. Can someone please assist/ guide me correctly, thanks |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Insert another file into an open document
You might try using a named range. But is the "file conversion" box asking
you how you want to connect to Excel? You'll probably get this dialog only if you have "Confirm conversion at Open" checked on the General tab of Tools | Options. OLEDB is the standard connection method for Word 2002 and above, but if you need DDE (to preserve number formatting), you can choose that. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "jasdeep" wrote in message ... Insert another file into an open document 1. Click where you want to insert the second document. 2. On the Insert menu, click Insert File. 3. To insert only part of a Microsoft Excel worksheet, click Range, and then type a cell range in the Range box. PROBLEM I am having a problem with step 3 above. After I type a cell range(e.g. B2, or e.g. A1:B3) into the range box then select insert, a File Conversion dialogue box appears. So at this point, Word is having difficulty in inserting excel cells. Can someone please assist/ guide me correctly, thanks |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not able to open 512MB word document | Microsoft Word Help | |||
HOw to decrypt a word doc | Microsoft Word Help | |||
Word 2003 | Microsoft Word Help | |||
insert a file directory and file list into a document | Microsoft Word Help | |||
How is the ~$... file created when you open a document used? | Microsoft Word Help |