LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Phil
 
Posts: n/a
Default How to create hyperlink from 2 cells, then open Word

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
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
How do I create a hyperlink to a web page in Excel? Olowalu Excel Discussion (Misc queries) 2 December 8th 05 03:56 AM
how do you get Word to open documents in it's own window(s)? othree7 Excel Discussion (Misc queries) 0 November 16th 05 04:21 PM
How do I use 3 cells to create the string for a lookup function? Bencomo Excel Worksheet Functions 1 May 15th 05 07:17 AM
Hyperlink to a word document JS Excel Discussion (Misc queries) 1 December 10th 04 10:49 PM
Hyperlink to word document problem JS Links and Linking in Excel 0 December 8th 04 10:54 PM


All times are GMT +1. The time now is 05:47 PM.

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

About Us

"It's about Microsoft Excel"