Linking Word And Excel

[Brady Finney]

I am trying to link several fields in Excel to a Word Doc. I'm linking the
fields using Ctrl-Paste as Hyperlink. The linking works fine. However,
when I try to save the files in different folders or move the files, all the
links are lost. This makes it very hard to replicate the linking for my 6
analysts. Any help would be greatly appreciated.

Brady

--
****************************************************************************
Brady T. Finney
Atlantic Management Company, Inc.
Orchard Park - Suite A12
875 Greenland Road
Portsmouth, NH 03801
603-436-8009 (Office)
617-413-4554 (Mobile)
603-427-0146 (Fax)
www.atlantic-mgmt.com

Atlantic Management Company is a leading valuation and financial advisory
firm
serving the business, legal, and financial communities through out New
England
from its offices in Portsmouth, New Hampshire.

Founded in 1968, the firm's Valuation Group provides business valuations,
fairness
and solvency opinions, and litigation support for private and public
companies. The
Ownership Transition Group specializes in mergers and acquisitions, ESOPs,
and
business succession strategies for privately owned companies and public
companies
desiring to go private.
****************************************************************************

 

[Bill Sharpe]

I am trying to link several fields in Excel to a Word Doc. I'm linking the
fields using Ctrl-Paste as Hyperlink. The linking works fine. However,
when I try to save the files in different folders or move the files, all the
links are lost. This makes it very hard to replicate the linking for my 6
analysts. Any help would be greatly appreciated.

Brady

Links break when you move files. Don't move them.

Bill

 

[Brady Finney]

Ok, that wasn't the answer I was hoping for. Maybe you have some insight
for a work around. Basically, I want to link our excel model to a report
template. For every client, I'd like to be able to rename the file and put
it in the cleint's sub-directory. Is there any way around this problem of
the links breaking?

Brady

 

[Ed]

Brady:

Sounds like you might need a macro that will SaveAs your Excel file into the
correct directory with a new name, then capture that name and insert a
hyperlink into the correct Word doc. Or are you trying to get the values of
specific cells into the Word doc?

Ed