| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
file path
I am trying to insert a file path from a word doc into a cell in an excel
spreadsheet. Then I want to take that cell and copy to another cell in the same spreadsheet and have the second cell link back to the word document. Any suggestions? (I also would rather not use vba) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
file path
=HYPERLINK("http://www.cnn.com","CNN")
Replace the CNN URL with your URL (filepath) and "CNN" with the name you want to give the file. See Excel's help for more info about HYPERLINK syntax. Example: =HYPERLINK(http://www.cnn.com) "Jane" wrote: I am trying to insert a file path from a word doc into a cell in an excel spreadsheet. Then I want to take that cell and copy to another cell in the same spreadsheet and have the second cell link back to the word document. Any suggestions? (I also would rather not use vba) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
file path
paste special as a LINK
"Jane" wrote: I am trying to insert a file path from a word doc into a cell in an excel spreadsheet. Then I want to take that cell and copy to another cell in the same spreadsheet and have the second cell link back to the word document. Any suggestions? (I also would rather not use vba) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| importing a particular excel worksheet into another excel file | Excel Worksheet Functions | |||
| Excel file and path Footers | Excel Discussion (Misc queries) | |||
| Using Relative path for XML data file? | Charts and Charting in Excel | |||
| File A and File B Together | Excel Discussion (Misc queries) | |||
| full path of excel file | Excel Discussion (Misc queries) | |||
Hybrid Mode
