Hello

I am writing a VB macro in Excel to populate some folder structures in few
cells. I would like to have these cells as hyperlinks so that one can click
on this cell to directly open that folder. Could anybody help me how to write
a hyperlink text in a cell through VB macro.

For example, my macro writes "C:\Documents and Settings\All Users" string
into cell A1. It should be written as a hyperlink so that user could go there
by simply clicking on the cell.

Please help.

Sri

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200811/1