Export a string to Excel to show as a hyperlink

[davjoh]

I want to export a string of data to Excel 2003 that contains the location of a file on my network (ie. file:///\\ss2\trace\text.txt ) and have Excel show it as a hyperlink so when the user clicks on the link it will open the specified file. Is this possible???

 

[Jason Chen]

I want to export a string of data to Excel 2003 that contains the location of a file on my network (ie. file:///\\ss2\trace\text.txt ) and have Excel show it as a hyperlink so when the user clicks on the link it will open the specified file. Is this possible???

Here are the example codes with MS VBA:

---------------------------------------------------
def var msxls-app as com-handle.

create "Excel.Application" msxls-app NO-ERROR.
msxls-app:workbooks:ADD.

/* select cell and put your data in **/
msxls-app:range("a1"):SELECT.
msxls-app:activecell:FormulaR1C1 = t-acct.

/* display and open excel file. outfile is the variable
which apply lib/rpt-opt.i **/


msxls-app:Visible = True.
msxls-app:Activeworkbook:SaveAs(outfile,
1,
"",
"",
FALSE,
FALSE,
3,
1,
1,
1) NO-ERROR.


-------------------------------------------------------

Good luck !:lol: