Answer to Re: Linking to two sheet in one workbook

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jim (me_at_hree.now)
Date: 03/22/05 

Date: Tue, 22 Mar 2005 13:54:23 GMT

I found out the answer. Copy the range of cells you want, switch to Word
and paste special, mark the link box and select as Excel object. The
embedded object behaves as it should. The insert object approach doesn't
seem to work at all.

"Jim" <me@hree.now> wrote in message
news:3YC_d.11832$oO4.11152@newsread3.news.pas.earthlink.net...
> I have an excel workbook with twenty four spreadsheets in it that rely on
> each other being there (can't seperate them into individual files). I am
> writing a report in Word that uses some of the sheets in the Excel file
via
> an "insert object" menu item in Word.
>
> My question is how do I link to an individual ***? When I link to the
> file it brings in the *** that was open during the last save of the
Excel
> file. I have to go and open the Excel file, select the correct ***,
save
> and exit (if it is not exited it doesn't insert correctly). I would
rather
> link to something like "\path\filename|sheetname". Is there a way to do
> this, can I change the link once made to point to the specific *** I
want?
> Any other thoughts?????
>
>

Quantcast