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: