I have developed a VB6 application that generates an Excel spreadsheet.
One of the columns contains email addresses. User would like to copy and paste a selection from that column directly into the "TO" box of his email utility (which happens to be Yahoo email).
Question: How do I write code that creates that column with "live" email addresses. That is, underlined and blue?
I am assuming that code that assigned column attributes would do it.