stustatester
asked on
importing htm files into excel sheet using VB
hi,
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.
e.g.
a html file contains:
<table>
<tr>
<td>hello</td>
<td>bye</td>
</tr>
</table>
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.
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.
e.g.
a html file contains:
<table>
<tr>
<td>hello</td>
<td>bye</td>
</tr>
</table>
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Accept EDDYKT's comment(s) as an answer.
Dan Rollins -- EE database cleanup volunteer