Skip to main content

Create HTML from a list of links

Sometimes we have a list of links and we like to convert it into HTML. Take the following example. Suppose I have a list of links as -

http://mp3nation.blogspot.com/
http://www.rungmasti.com/include/music/album.php?subCatID=86
http://www.emp3world.com/
http://www.newestmp3s.net/
http://www.mp3fusion.net/
http://www.bigmp3.org/
http://www.cooltoad.com/
http://www.seekasong.com/
http://www.mp3-center.org/
http://www.e-mp3s.eu/

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.
But what of I have 50 links or more? It becomes a laborious process so I wrote a small VBA script to do the job.
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
Range("A65536").End(xlUp).Select
rc = Selection.Row

For i = 1 To rc
Cells(i, 1).Select
p = Selection.Value
If p <> "" Then
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
p, TextToDisplay:=p
End If
Next

End Sub

Comments

Popular posts from this blog

Fastest way to send multiple drafts from gmail

People claim that the fastest way to send multiple email drafts is to use Gmail IMAP with email client like Outlook or Evolution or Thunderbird. But I have found this is not true. Because Thunderbird and Evolution etc. email clients treats the drafts as emails still to be edited. So it is not just simple select all and hit send. Each email draft has to be opened and sent separately. That is a lot of clicks and mouse movements, wasting precious time and energy. I have a better solution which involves minimum keystrokes and mouse usage. Efficiency booster technique for sending emails.
If someone is feeling adventurous and want to try it from the Gmail interface itself, here's how to do it in the fastest possible manner. It involves using the mouse once. Select the first draft. Gmail would open a new email box and put the cursor inside the box to write.Press TAB once to go the Send button.Press ENTER to send. Now Gmail sends it and the box is gone but the highlight goes to the last li…

LYRICS OF CHANDRABINDOO

___________________________________________________________________

SWEET HEART FROM AAR JAANI NAA(T-SERIES)
-- SWEETHEART --

Pratham college-er din ta
Aajo thik e mone poRey scene ta
Dada didi haath dhorey siNRi tei bose poRey
Aamar chokh ta ghorey bon bon bon bon

Sweetheart, I am seating alone
Sweetheart, for me there is none

DhoNk gile chole gelo pratham maas
Meye dekhlei feli deergho-shwash
DhoNk gile chole gelo pratham maas
Meye dekhlei othe nabhishwash
Meyera bheeshan smart poRey chhoto mini-skirt
Aamar e je sheet korey kon kon kon kon

Sweetheart, I am seating alone
Sweetheart, for me there is none

Taarporey kete gelo maas chaar
Fuse holo je kato future
Bandhura purse khule eke oke taake tole
Aamar pran ta korey chon mon chon mon

Sweetheart, I am seating alone
Sweetheart, for me there is none

Ekdin lawn theke beriye
Ek tanayaar dike taakiye
Hawt korey ki je holo magaj ta ghurey gelo
Taar kaaner saamne kori ghyan ghyan ghyan ghyan

Sweetheart, I am seating alone
Sweetheart, for me there is none

Taarpore cla…

How to join audio tracks smoothly in Audacity

Audio tracks can be mixed easily in full fledged video editors like kdenlive or Adobe Premiere but for mixing or joining audio they would not provide the amount of control that audio editors like Audacity provide. The example I am going to show today would demonstrate the range of tools in Audacity that allows us to control the waveform and to mold it to our desire.

Today I am going to take a small track like a small 1 min. clip of storm sound and make a long continuous sounding storm audio clip from it.

STEP 1 : Open file
Open the clip in Audacity.

STEP 2 : Removing unwanted audio portion
There is always unwanted sections of the audio that we have to discard. Select the portion of background noise or unwanted audio.


Press DELETE key.

STEP 3 : Duplicating the track
Now we make a copy of the entire waveform and paste it at the end of the track.

Select the SELECT tool (the one which looks like I). Then select the whole waveform and prss Ctrl+c. Now click approximately at the end of the…