| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I display the pathname/address of a hyperlink?
I have a spreadsheet that links to other sheets and word documents. Does
anyone know of a quick way to change the view/display so that it would display the actual pathname of the linked files rather than the name as I have it now? Please advise. Thank you in advance for your response. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I display the pathname/address of a hyperlink?
The easiest way is to use the following form for your hyperlinks:
=HYPERLINK("C:\temp\xwer.xls#Sheet2!B9","target") The cell normally displays: target simply touch CNTRL-` This will change the display to formula mode and you can see the path/filename. -- Gary''s Student - gsnu200736 "DMAnalyst" wrote: I have a spreadsheet that links to other sheets and word documents. Does anyone know of a quick way to change the view/display so that it would display the actual pathname of the linked files rather than the name as I have it now? Please advise. Thank you in advance for your response. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I display the pathname/address of a hyperlink?
Hi, thank you for the response but it's not quite I'm looking for --
I already have the links built in. I need to export the information into another program and it would be useful to be able to pull the information in as the actual pathname rather than the label. That's what it is doing right now. I need a quick way to change from the way it's displaying right now which is the label to the pathname. E.g. Current display: F06 Sample Effort Preferred display: H:/Marketing Drive/Sample Effort.xls Please help if you can. Thank you. "Gary''s Student" wrote: The easiest way is to use the following form for your hyperlinks: =HYPERLINK("C:\temp\xwer.xls#Sheet2!B9","target") The cell normally displays: target simply touch CNTRL-` This will change the display to formula mode and you can see the path/filename. -- Gary''s Student - gsnu200736 "DMAnalyst" wrote: I have a spreadsheet that links to other sheets and word documents. Does anyone know of a quick way to change the view/display so that it would display the actual pathname of the linked files rather than the name as I have it now? Please advise. Thank you in advance for your response. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I display the pathname/address of a hyperlink?
Hi, thank you for the response but it's not quite I'm looking for --
I already have the links built in. I need to export the information into another program and it would be useful to be able to pull the information in as the actual pathname rather than the label. That's what it is doing right now. I need a quick way to change from the way it's displaying right now which is the label to the pathname. E.g. Current display: F06 Sample Effort Preferred display: H:/Marketing Drive/Sample Effort.xls Please help if you can. Thank you. "Gary''s Student" wrote: The easiest way is to use the following form for your hyperlinks: =HYPERLINK("C:\temp\xwer.xls#Sheet2!B9","target") The cell normally displays: target simply touch CNTRL-` This will change the display to formula mode and you can see the path/filename. -- Gary''s Student - gsnu200736 "DMAnalyst" wrote: I have a spreadsheet that links to other sheets and word documents. Does anyone know of a quick way to change the view/display so that it would display the actual pathname of the linked files rather than the name as I have it now? Please advise. Thank you in advance for your response. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I display the pathname/address of a hyperlink?
O.K. then...
It will take a tiny bit of VBA Check back later... -- Gary''s Student - gsnu200736 "DMAnalyst" wrote: Hi, thank you for the response but it's not quite I'm looking for -- I already have the links built in. I need to export the information into another program and it would be useful to be able to pull the information in as the actual pathname rather than the label. That's what it is doing right now. I need a quick way to change from the way it's displaying right now which is the label to the pathname. E.g. Current display: F06 Sample Effort Preferred display: H:/Marketing Drive/Sample Effort.xls Please help if you can. Thank you. "Gary''s Student" wrote: The easiest way is to use the following form for your hyperlinks: =HYPERLINK("C:\temp\xwer.xls#Sheet2!B9","target") The cell normally displays: target simply touch CNTRL-` This will change the display to formula mode and you can see the path/filename. -- Gary''s Student - gsnu200736 "DMAnalyst" wrote: I have a spreadsheet that links to other sheets and word documents. Does anyone know of a quick way to change the view/display so that it would display the actual pathname of the linked files rather than the name as I have it now? Please advise. Thank you in advance for your response. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I display the pathname/address of a hyperlink?
O.K. then...
It will take a tiny bit of VBA Check back later... -- Gary''s Student - gsnu200736 "DMAnalyst" wrote: Hi, thank you for the response but it's not quite I'm looking for -- I already have the links built in. I need to export the information into another program and it would be useful to be able to pull the information in as the actual pathname rather than the label. That's what it is doing right now. I need a quick way to change from the way it's displaying right now which is the label to the pathname. E.g. Current display: F06 Sample Effort Preferred display: H:/Marketing Drive/Sample Effort.xls Please help if you can. Thank you. "Gary''s Student" wrote: The easiest way is to use the following form for your hyperlinks: =HYPERLINK("C:\temp\xwer.xls#Sheet2!B9","target") The cell normally displays: target simply touch CNTRL-` This will change the display to formula mode and you can see the path/filename. -- Gary''s Student - gsnu200736 "DMAnalyst" wrote: I have a spreadsheet that links to other sheets and word documents. Does anyone know of a quick way to change the view/display so that it would display the actual pathname of the linked files rather than the name as I have it now? Please advise. Thank you in advance for your response. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I display the pathname/address of a hyperlink?
Run this tiny macro on the active sheet:
Sub hyperverter() For Each Hyperlink In ActiveSheet.Hyperlinks Hyperlink.TextToDisplay = Hyperlink.Address Next End Sub It will convert each hyperlink so the displayed "friendly name" will be the address. -- Gary''s Student - gsnu200736 "DMAnalyst" wrote: Hi, thank you for the response but it's not quite I'm looking for -- I already have the links built in. I need to export the information into another program and it would be useful to be able to pull the information in as the actual pathname rather than the label. That's what it is doing right now. I need a quick way to change from the way it's displaying right now which is the label to the pathname. E.g. Current display: F06 Sample Effort Preferred display: H:/Marketing Drive/Sample Effort.xls Please help if you can. Thank you. "Gary''s Student" wrote: The easiest way is to use the following form for your hyperlinks: =HYPERLINK("C:\temp\xwer.xls#Sheet2!B9","target") The cell normally displays: target simply touch CNTRL-` This will change the display to formula mode and you can see the path/filename. -- Gary''s Student - gsnu200736 "DMAnalyst" wrote: I have a spreadsheet that links to other sheets and word documents. Does anyone know of a quick way to change the view/display so that it would display the actual pathname of the linked files rather than the name as I have it now? Please advise. Thank you in advance for your response. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I display the pathname/address of a hyperlink?
Run this tiny macro on the active sheet:
Sub hyperverter() For Each Hyperlink In ActiveSheet.Hyperlinks Hyperlink.TextToDisplay = Hyperlink.Address Next End Sub It will convert each hyperlink so the displayed "friendly name" will be the address. -- Gary''s Student - gsnu200736 "DMAnalyst" wrote: Hi, thank you for the response but it's not quite I'm looking for -- I already have the links built in. I need to export the information into another program and it would be useful to be able to pull the information in as the actual pathname rather than the label. That's what it is doing right now. I need a quick way to change from the way it's displaying right now which is the label to the pathname. E.g. Current display: F06 Sample Effort Preferred display: H:/Marketing Drive/Sample Effort.xls Please help if you can. Thank you. "Gary''s Student" wrote: The easiest way is to use the following form for your hyperlinks: =HYPERLINK("C:\temp\xwer.xls#Sheet2!B9","target") The cell normally displays: target simply touch CNTRL-` This will change the display to formula mode and you can see the path/filename. -- Gary''s Student - gsnu200736 "DMAnalyst" wrote: I have a spreadsheet that links to other sheets and word documents. Does anyone know of a quick way to change the view/display so that it would display the actual pathname of the linked files rather than the name as I have it now? Please advise. Thank you in advance for your response. |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I display the pathname/address of a hyperlink?
You are super-duper awesome. It works!!! Thank you so much.
"Gary''s Student" wrote: Run this tiny macro on the active sheet: Sub hyperverter() For Each Hyperlink In ActiveSheet.Hyperlinks Hyperlink.TextToDisplay = Hyperlink.Address Next End Sub It will convert each hyperlink so the displayed "friendly name" will be the address. -- Gary''s Student - gsnu200736 "DMAnalyst" wrote: Hi, thank you for the response but it's not quite I'm looking for -- I already have the links built in. I need to export the information into another program and it would be useful to be able to pull the information in as the actual pathname rather than the label. That's what it is doing right now. I need a quick way to change from the way it's displaying right now which is the label to the pathname. E.g. Current display: F06 Sample Effort Preferred display: H:/Marketing Drive/Sample Effort.xls Please help if you can. Thank you. "Gary''s Student" wrote: The easiest way is to use the following form for your hyperlinks: =HYPERLINK("C:\temp\xwer.xls#Sheet2!B9","target") The cell normally displays: target simply touch CNTRL-` This will change the display to formula mode and you can see the path/filename. -- Gary''s Student - gsnu200736 "DMAnalyst" wrote: I have a spreadsheet that links to other sheets and word documents. Does anyone know of a quick way to change the view/display so that it would display the actual pathname of the linked files rather than the name as I have it now? Please advise. Thank you in advance for your response. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink: Why am I getting ../../../ in the address bar? | Excel Discussion (Misc queries) | |||
| hyperlink a worksheet with no address | Excel Worksheet Functions | |||
| Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
| How to get 500 hyperlink address efficiently? | Excel Discussion (Misc queries) | |||
| Can VBA edit hyperlink(s) address | Excel Discussion (Misc queries) | |||
Linear Mode
