ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hyperlink in csv file not working properly (https://www.excelbanter.com/excel-discussion-misc-queries/140543-hyperlink-csv-file-not-working-properly.html)

TracyM

Hyperlink in csv file not working properly
 
I have a perl script that creates a csv file and e-mails it to an e-mail
address. However, the hyperlink is not working. It is listed as

HYPERLINK("<http://www.website.com/directory/filename.cgi?id=122222")

I want the actual hyperlink to be "clickable" for the user to be
automatically redirected to the website. Not have to copy and past text.

Does anyone have any Ideas?

Dave Peterson

Hyperlink in csv file not working properly
 
And if you added an equal sign to that formula, would it work:

=hyperlink(...)



TracyM wrote:

I have a perl script that creates a csv file and e-mails it to an e-mail
address. However, the hyperlink is not working. It is listed as

HYPERLINK("<http://www.website.com/directory/filename.cgi?id=122222")

I want the actual hyperlink to be "clickable" for the user to be
automatically redirected to the website. Not have to copy and past text.

Does anyone have any Ideas?


--

Dave Peterson


All times are GMT +1. The time now is 06:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com