importing htm files into excel sheet using VB
Posted on 2003-11-18
i would like to write a macro inside a excel table, which do the following things.
say i have a folder contains several html files.
i want to import the file names, the characters from all the html files ("the source code"),
and then filter the texts i want.
a html file contains:
i want to search the character ">" and copy all the text after it till i find "<",
like ">"hello"<", i want to have hello which is between ">" and "<".
any body could help me? thanx.