and I want them not as text but as links. For that I have to
- Manually type
tag for each.
- I can paste them in MSWord and click enter after each link and MSWord would automatically make them hyperlinks. That works really good.
I just paste the list of links in first column of an empty Excel sheet. Then paste the following code in Visual Basic Editor for Excel and run it as a Macro or we can make a command button for it,
whatever procedure suits anyone. After running all one has to do is copy the list of links and paste into Frontpage and save it as a HTML file.
Here's the code.
Sub HREF( )
' Macro to create hyperlinks out of a list of links
'find the last row contining data
rc = Selection.Row
For i = 1 To rc
p = Selection.Value
If p <> "" Then
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _