I got a Access database table with one of its table storing :
as text, the filed name lets say is folder_path
then i use the 'worksheets("Sheet1").CopyFromRecordset rs' to paste the whole table onto sheet1, where rs is the recordset having the query result
my problem is... i need to let user to click on the folder_path and it will automatically open up the folder, however the 'file:///E:/Temp/' appear as a normal text in Excel, which i cannot click on it as a hyperlink
wat should i do to format the cell to show the text as hyperlink? it has to be done in code and dynamically.
Thanks a lot.