Hyperlink an embedded Excel spreadsheet cell to part of the WORD doc it's in?

[JoAnn]

Hi,

I have tried the Excel user group but haven't had any
responses yet so I'm hoping there might be a way to do
this using VBA.

I have an Excel spreadsheet embedded in a Word document.
The spreadsheet references instruction steps contained in
another part of the same Word document.

Is it possible to create an Excel hyperlink that can go to
the bookmarked instruction steps contained in that same
open WORD document? If so, how would I do that?

Thank you!
JoAnn

 

[Jean-Guy Marcil]

Hi JoAnn,

Yes you can.

Open you Excel workbook;
Select the text that you want to use as hyperlink;
Hit CTRL-K;
In the address field near the bottom, type the name of the Word document and
the bookmark name like so:
[ Test.doc#MyBookmark ];
Save your Excel workbook;
Open the Word document where you want to embed the excel data ("Test.doc" in
my example above);
Place the cursor where you want the data to go;
Go back to Excel;
Select the data;
Hit CTRL-C;
Go back to Word;
From the Edition Menu, select "Paste special...";
Select Paste with links;
Then, in the list on the right, select HTML format;
Click OK;
Save Word.

The Excel hyperlink should now refer to the bookmark in the same Word
document.

--
Cheers!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[JoAnn]

Thank you! I will give that a try.

-----Original Message-----
Hi JoAnn,

Yes you can.

Open you Excel workbook;
Select the text that you want to use as hyperlink;
Hit CTRL-K;
In the address field near the bottom, type the name of the Word document and
the bookmark name like so:
[ Test.doc#MyBookmark ];
Save your Excel workbook;
Open the Word document where you want to embed the excel data ("Test.doc" in
my example above);
Place the cursor where you want the data to go;
Go back to Excel;
Select the data;
Hit CTRL-C;
Go back to Word;
From the Edition Menu, select "Paste special...";
Select Paste with links;
Then, in the list on the right, select HTML format;
Click OK;
Save Word.

The Excel hyperlink should now refer to the bookmark in the same Word
document.

--
Cheers!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org


"JoAnn" <[email protected]> a écrit dans le message de

Hi,

I have tried the Excel user group but haven't had any
responses yet so I'm hoping there might be a way to do
this using VBA.

I have an Excel spreadsheet embedded in a Word document.
The spreadsheet references instruction steps contained in
another part of the same Word document.

Is it possible to create an Excel hyperlink that can go to
the bookmarked instruction steps contained in that same
open WORD document? If so, how would I do that?

Thank you!
JoAnn

.

 

[JoAnn]

Hi,Jean-Guy
I tried it with 1 variation -- I have to have mine pasted
in as an Excel object (vs. html) so they can access/edit
the worksheet from within Word.

The links work fine but I don't have access to the back
arrow to return to the worksheet from the bookmarked Word
section. However, if I were opening/using this initially
from within Excel, I can use the back arrow to return to
the worksheet.

I guess this all makes sense when you consider which
application has control at the time but is there any way
to provide the capability to return to the Excel
spreadsheet -- or -- is my only recourse to create
a "Back" macrobutton in the Word instruction section that
brings them back to the page with the spreadsheet?


Thanks again!
JoAnn

-----Original Message-----
Hi JoAnn,

Yes you can.

Open you Excel workbook;
Select the text that you want to use as hyperlink;
Hit CTRL-K;
In the address field near the bottom, type the name of the Word document and
the bookmark name like so:
[ Test.doc#MyBookmark ];
Save your Excel workbook;
Open the Word document where you want to embed the excel data ("Test.doc" in
my example above);
Place the cursor where you want the data to go;
Go back to Excel;
Select the data;
Hit CTRL-C;
Go back to Word;
From the Edition Menu, select "Paste special...";
Select Paste with links;
Then, in the list on the right, select HTML format;
Click OK;
Save Word.

The Excel hyperlink should now refer to the bookmark in the same Word
document.

--
Cheers!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org


"JoAnn" <[email protected]> a écrit dans le message de

Hi,

I have tried the Excel user group but haven't had any
responses yet so I'm hoping there might be a way to do
this using VBA.

I have an Excel spreadsheet embedded in a Word document.
The spreadsheet references instruction steps contained in
another part of the same Word document.

Is it possible to create an Excel hyperlink that can go to
the bookmarked instruction steps contained in that same
open WORD document? If so, how would I do that?

Thank you!
JoAnn

.

 

[Jean-Guy Marcil]

"JoAnn" <[email protected]> a écrit dans le message de

Hi,Jean-Guy
I tried it with 1 variation -- I have to have mine pasted
in as an Excel object (vs. html) so they can access/edit
the worksheet from within Word.

Strange... With XP, when I used Paste with link as Excel object, the
hyperlink did not work...
By the way, in HTML format, you can still modify the original Excel sheet
from within Word, instead of double-clicking, right-click and choose "Open
link..."

The links work fine but I don't have access to the back
arrow to return to the worksheet from the bookmarked Word
section. However, if I were opening/using this initially
from within Excel, I can use the back arrow to return to
the worksheet.

The thing I noticed is that the Web toolbar does not automatically appear
when I use the embedded Excel hyperlink to go to a page further down in the
document. But, if I right click the toolbar area and display the Web
toolbar, I then can use the back button to go back to the place in the Word
document where the embedded Excel sheet (and the starting point) is.

You could add code to the template so that whenever the document is opened,
the Web toolbar is made visible, then made invisible when the document is
closed.
If not, the back button next to the arival point yu mentioned would work,
but it would also print!

--
Cheers!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[JoAnn]

Thanks again!
JoAnn

-----Original Message-----
dans le message de


Strange... With XP, when I used Paste with link as Excel object, the
hyperlink did not work...
By the way, in HTML format, you can still modify the original Excel sheet
from within Word, instead of double-clicking, right-click and choose "Open
link..."


The thing I noticed is that the Web toolbar does not automatically appear
when I use the embedded Excel hyperlink to go to a page further down in the
document. But, if I right click the toolbar area and display the Web
toolbar, I then can use the back button to go back to the place in the Word
document where the embedded Excel sheet (and the starting point) is.

You could add code to the template so that whenever the document is opened,
the Web toolbar is made visible, then made invisible when the document is
closed.
If not, the back button next to the arival point yu mentioned would work,
but it would also print!

--
Cheers!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org



.