Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello,
The purpose of this endeavour is to create a cell that when the user clicks on it, it will open up a Word file that THAT particular cell represents. FIRST STEP: Take the values from Column D (Tract Number), then add a ".doc" extension to it, then put the UNC filepath (\\server\data\reports) in front of all of that and put it in Column E. See me example below: File path plus Tract Number plus Extension \\server\data\reports\ 7-5-065-085 .doc .... to generate something like this: \\server\data\reports\7-5-065-085.doc SECOND STEP: Use the value (only when the user clicks on the hyperlink) from the cell in Column E and start up Word. Can this be done? Thanks in advance for all of your replies. Phil. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a hyperlink to a web page in Excel? | Excel Discussion (Misc queries) | |||
how do you get Word to open documents in it's own window(s)? | Excel Discussion (Misc queries) | |||
How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions | |||
Hyperlink to a word document | Excel Discussion (Misc queries) | |||
Hyperlink to word document problem | Links and Linking in Excel |