convert cell content to html automatically

[Guest]

I am managing in excel a flat database of over 1000 names, committees, etc., where email addresses are found using vlookup function. How do I convert these results to html so that when they are published on the web they are active email addresses. I know I can laboriously on each cell do this: F2 (edit formula) F9 (value) Enter. That seems to convert what looks like an email address to html (but nowhere can I find instructions about that). I need to be able to do this for all cells at once. I've tried writing a macro, but I don't seem to be able to recortd the editing steps described above.

 

[Myrna Larson]

Select all of the cells containing email addressses and run this macro.

Sub MakeHyperLinks()
Dim Cell As Range
Dim WS As Worksheet

Set WS = Selection.Parent
For Each Cell In Selection
WS.Hyperlinks.Add Cell, Cell.Value
Next Cell

End Sub

I am managing in excel a flat database of over 1000 names, committees, etc.,

where email addresses are found using vlookup function. How do I convert these
results to html so that when they are published on the web they are active
email addresses. I know I can laboriously on each cell do this: F2 (edit
formula) F9 (value) Enter. That seems to convert what looks like an email
address to html (but nowhere can I find instructions about that). I need to be
able to do this for all cells at once. I've tried writing a macro, but I don't
seem to be able to recortd the editing steps described above.

 

[Guest]

Thanks, Myrna: that gets me halfway there. However, the hyperlink references are cluttered with the path:file\\c:\\etc.etc. which has to be removed before they can be used as email links.

 

[David McRitchie]

instead of cell.value
try "mailto:" & cell.value

Thanks, Myrna: that gets me halfway there. However, the hyperlink references are cluttered with the path:file\\c:\\etc.etc. which

has to be removed before they can be used as email links.function. How do I convert these results to html so that when they are published on the web they are active email addresses. I know
I can laboriously on each cell do this: F2 (edit formula) F9 (value) Enter. That seems to convert what looks like an email address
to html (but nowhere can I find instructions about that). I need to be able to do this for all cells at once. I've tried writing a
macro, but I don't seem to be able to recortd the editing steps described above.