Inserting a hyperlink through ADO

[Chris Hardie]

Hi,

I'm using ADO in my ASP page to insert data into an Excel spreadsheet,
but I am having difficulty inserting a hyperlink. When I try to add
=HYPERLINK("http://sometite.com", "Click here") to the spreadsheet,
the expression gets hard coded into the cell instead of evaluating
down into a hyperlink. The only way to turn it into a link is to
double click the cell, which would be time-consuming as I have
thousands of records to complete.

Anyone have any ideas?

Thanks,

Chris

 

[Jim Cone]

Chris,

No guarantees, but give something like this a try...

Range("B10").Formula = "=HYPERLINK(""http://sometite.com"", ""Click here"")"

Regards,
Jim Cone
San Francisco, USA

 

[Jake Marx]

Hi Chris,

I'm using ADO in my ASP page to insert data into an Excel spreadsheet,
but I am having difficulty inserting a hyperlink. When I try to add
=HYPERLINK("http://sometite.com", "Click here") to the spreadsheet,
the expression gets hard coded into the cell instead of evaluating
down into a hyperlink. The only way to turn it into a link is to
double click the cell, which would be time-consuming as I have
thousands of records to complete.

I'm not sure if this is possible through ADO. AFAIK, ADO will only allow
you to retrieve/update cell *values*, not formulas.

If you need to modify formulas, I think you'd have to go with Automation
(not advised on a web server) or something like ExcelWriter:

http://officewriter.softartisans.com/officewriter-37.aspx

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

 

[Tim Williams]

Are you creating a file for download, or using an Excel file on the server
as a database?
It's not clear from your post exactly which you're doing.

If creating for download, are you using Excel automation or creating the
sheet via HTML/XML?


Tim.