Creating a hyperlink in an excel worksheet

mcmahling
mcmahling used Ask the Experts™
on
I have a delphi 2006 vcl application that exports data to an excel worksheet using Scalabuim SMExport vcl. In the spreadsheet, I have a column that holds the location of HTML files. I would like the to be able to open the html file when the user clicks on the text in the html field. Can anyone suggest how I would do that in delphi?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Eddie ShipmanAll-around developer

Commented:
Have you tried formatting the location of the file as a URL?
Eddie ShipmanAll-around developer

Commented:
kind of like this:
'<a href="file:///' + location_to_file + '">'

Open in new window

All-around developer
Commented:
oops, more like this:
'<a href="file:///' + location_to_file + '">'+ File_Name + '</a>'

Open in new window

Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
I could not get your solution to work. But your solution did start me searching in a direction that provided an answer I could get to work.  I found that I could insert the command "=HyperLink(file address.html) and the link opened the file when clicked.
Eddie ShipmanAll-around developer

Commented:
I forgot about the =Hyperlink function.
Eddie ShipmanAll-around developer

Commented:
Thanks for the points. I wouldn't have objected to a deletion, however, because you found your own answer.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial