Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 11th 06, 03:34 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 4
Default Excel Hyperlink doesn't open Word doc the same way as Word does

I set up a hyperlink in Excel that points to a Word Doc, the only problem is
that is doesn't open up it up the same way as just double clicking on the
file itself or opening it up in Word.

How you ask?

Well, I have a large contact list and each file goes to a certain
pre-selected contact which is saved that way. When I open up the file from
within Word or double click the file itself, the recipient's name shows (the
email toolbar button is selected automatically), but when I click on the
Hyperlink in Excel, the Word doc opens up without the email button selected
by default and without the recipients name there. This forces me to then
click on the email button to bring this information up.

Anyone know of a way to have the email information automatically selected
when opening up a hyperlink in Excel to a Word doc?

Does Excel have a way of using shortcuts instead? Maybe a shorcut to a Word
Doc will open it in up the same way as Word will.

Thanks in advance.


  #2   Report Post  
Old October 12th 06, 03:13 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 4
Default These are thoughts from an Expert Word user. Can any Excel pros ex

I think you'd need to create buttons linked to macro code that opens the
documents. It would be best to start on this from an Excel newsgroup
(excel.programming), as they can tell you which buttons are best to use and
how
to assign a macro to them.

Ideally, you'd use the same macro for each button. There'd be something about
the button (the caption, or a "tag") you can use to identify which button /
document has been clicked. The macro can check this, then open the correct
document. So you should also mention you need to know this.

The Excel folks may also be able to give you the code to open the Word
documents. If not, you can ask in a word.vba newsgroup for the "finishing
touches".

"duugg" wrote:

I set up a hyperlink in Excel that points to a Word Doc, the only problem is
that is doesn't open up it up the same way as just double clicking on the
file itself or opening it up in Word.

How you ask?

Well, I have a large contact list and each file goes to a certain
pre-selected contact which is saved that way. When I open up the file from
within Word or double click the file itself, the recipient's name shows (the
email toolbar button is selected automatically), but when I click on the
Hyperlink in Excel, the Word doc opens up without the email button selected
by default and without the recipients name there. This forces me to then
click on the email button to bring this information up.

Anyone know of a way to have the email information automatically selected
when opening up a hyperlink in Excel to a Word doc?

Does Excel have a way of using shortcuts instead? Maybe a shorcut to a Word
Doc will open it in up the same way as Word will.

Thanks in advance.

  #3   Report Post  
Old October 12th 06, 03:14 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 4
Default A reply from an expert Word user, Any thoughts on how utilize this



"duugg" wrote:

I set up a hyperlink in Excel that points to a Word Doc, the only problem is
that is doesn't open up it up the same way as just double clicking on the
file itself or opening it up in Word.

How you ask?

Well, I have a large contact list and each file goes to a certain
pre-selected contact which is saved that way. When I open up the file from
within Word or double click the file itself, the recipient's name shows (the
email toolbar button is selected automatically), but when I click on the
Hyperlink in Excel, the Word doc opens up without the email button selected
by default and without the recipients name there. This forces me to then
click on the email button to bring this information up.

Anyone know of a way to have the email information automatically selected
when opening up a hyperlink in Excel to a Word doc?

Does Excel have a way of using shortcuts instead? Maybe a shorcut to a Word
Doc will open it in up the same way as Word will.

Thanks in advance.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pasting charts to Word from Excel as picture Hari Charts and Charting in Excel 5 July 5th 06 08:04 PM
how do I open an excel spreadsheet attachment from microsoft word? Karen New Users to Excel 3 May 30th 06 05:37 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Cannot open excel inside word document SF Excel Discussion (Misc queries) 0 August 30th 05 09:12 PM
How do you open a word document from inside excel by using hyperl. fadkub Excel Discussion (Misc queries) 1 December 29th 04 04:53 PM


All times are GMT +1. The time now is 12:09 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017