Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 11th, 2006, 12:52 PM
Registered User
 
Join Date: Dec 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Hyperlink (Concatenate)

I am trying to hyperlink from one workbook to another. Aside from opening the destination workbok with the hyperlink, I would also like to display the value of a specific cell that resides in the destination workbook within the cell of the original workbook that contains the hyperlink.

I tried this at Mr. Excel but was told that a hyperlinked cell cannot be used to display a value from another workbook. But I do not think that is correct.

 
Old January 11th, 2006, 01:09 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 173
Thanks: 0
Thanked 3 Times in 3 Posts
Default

You can do this:

- Take the workbook (1st) you want to create the externally linked hyperlink in and open it
- Also open the other workbook (2nd) that you want to link / hyperlink to
- In the 1st workbook in any cell start typing a formula (by typing =)
- Whilst still editing the formula switch to the 2nd workbook (by pressing Ctrl + F6 amongst other ways)
- Navigatve to the desired sheet in the 2nd workbook by clicking on the sheet tabs at the bottom
- Click on the cell whose value you'd like to externally link
- Press Enter
- Switch back to the 2nd workbook and close it
- In the first workbook click on the externally linked cell which will show the value of the other spreadsheet's cell
- Press Ctrl + K to bring up the Edit Hyperlinks dialog box
- Use the file browse dialog to navigate to the linked file (2nd workbook)
- Select the linked file and press ok
- You will have an externally linked hyperlinked cell






Similar Threads
Thread Thread Starter Forum Replies Last Post
concatenate records davehodges Access 5 November 1st, 2007 10:13 AM
Concatenate Rows stonesbg ASP.NET 2.0 Basics 5 February 6th, 2007 06:12 PM
Argh! Why does this concatenate? interrupt Javascript How-To 1 August 13th, 2005 08:44 AM
concatenate with characters lily611 ADO.NET 1 July 21st, 2004 08:10 AM
Concatenate numbers fs22 Javascript 1 April 25th, 2004 06:51 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.