Setting Excel hyperlink base in VBA

I am running Excel 2003. I have many .xls files, each of which has many HYPERLINK calls. e.g. <=HYPERLINK("http://journeyplanner.tfl.gov.uk/user/XSLT_TRIP_REQUEST2?la ...

Message posted on the May 6th, 2013 - 3:02 AM ET

Kronos® Momentum Accelerates in EMEA Region

Kronos® Incorporated today announced that it is seeing increasing momentum in the Europe, Middle East, and Africa (EMEA) region fueled by growing demand for workforce management solutions. In response, the company ...

Press published on the January 17th, 2011 - 8:00 AM ET

Excel hyperlink problem after sorting

I sort one of my Excel 2002 spreadsheets by data in the columns. I recently added hyperlinks to the data in one of the columns and then, to my horror and disbelief, discovered that when I resorted the data the hyperlinks no longer matched their ...

Message posted on the August 16th, 2011 - 2:47 PM ET

excel hyperlink text to display and vlookup

Good Day, hope that you possibly can help me. I tried below function in an Excel sheet. It works well until I change the text to display for the hyperlink, for e.g. to cnn instead of http://www.cnn.com. Then the link doesn’t work anymore. ...

Message posted on the June 26th, 2009 - 1:23 AM ET

Excel hyperlink to Word docs

I have a Table of Contents in Excel. I want to hyperlink each item in the TOC to a word document.

Message posted on the March 24th, 2010 - 9:55 AM ET

Excel hyperlink to another open Excel file - wants to reopen file

I am using hyperlinks to link two excel files but when I click on the hyperlink, it want s to open the other file even when it is already open. This leads to warnings about replacing the existing file, dialog boxes to enable or disable macros, etc. ...

Message posted on the March 6th, 2009 - 3:32 PM ET

Excel Hyperlink to internal destination

Operating System: Mac OS X 10.5 (Leopard) OK, I feel like an idiot having to post what should be, a very simple thing to do. However, I'm completely perplexed as to how to make a 'hyperlink' to another spot in the same file. Example: I would like ...

Message posted on the January 7th, 2009 - 11:53 PM ET

Excel hyperlink loses its path on save (2)

I have a Hyperlink in my worksheet that points to a document on our network server, but when I save this file and email it to the group the hyperlink changes to point to my hard drive where the document is not located. Tools -> Options -> ...

Message posted on the June 15th, 2009 - 11:52 AM ET

excel hyperlink to object

I believe in the past I was able to change a hyperlink to an embedded object. Now in Excel 2007, I can't find a way to do this. Any help or ideas? thanks.

Message posted on the March 3rd, 2009 - 11:38 AM ET

Excel hyperlink within workbook and SharePoint drafts

We have excel workbooks with sheets that contain hyperlinks to other sheets within the workbook. We have these workbooks saved to a WSS 3.0 site. When using Excel 2007 to edit one of these workbooks we use the local sharepoint drafts folder. However ...

Message posted on the April 9th, 2010 - 1:08 PM ET

excel hyperlink not working

A co-worker is trying to create hyperlinks in different cells which link to files in a shared network directory. When he sends the files out, no one can access the links, they refer to a local directory (ie: file:///C:Documents and Settings - and ...

Message posted on the November 12th, 2009 - 11:33 AM ET

Can't set hyperlink to Word bookmark

Excel 2007 (& Word 2007) Vista Enterprise SP1 This topic has been covered re older versions of Excel, with no definitive answer. I want to hyperlink a certain Excel cell to a specific point in a Word document. I select the cell, hit Ctrl-k, ...

Message posted on the April 20th, 2010 - 4:48 PM ET

Excel Hyperlinks to my Media Player do not work

Fellow Forum Members, I have tested this on Excel 2003 & 2007 with no success. My objective is to setup 50 hyperlinks to 50 FLV files located in the same directory where my Excel file is located. A FLV file is a Flash video file that does not ...

Message posted on the January 22nd, 2009 - 12:48 AM ET

Links from Word to a Cell in Excel

I cannot accept the possibility that there is not a way to do this. Al I want to do, is this: I have a long manual in Word. It contains a lot of text. I would lik some of the text to link to a 'specific' cell in Excel. Hyperlink don't work, ...

Message posted on the April 12th, 2010 - 3:23 PM ET