PDA

View Full Version : get html img src filenames by Excel VBA



parscon
05-10-2013, 02:03 PM
I have about 200 offline web page HTML files. I have many img tag and I need to grab their file name .

Exmaple :


<tr><td><img src="directory/directory/sample/imagename.jpeg">
</td></tr>
Here will be some other code

after run the code copy just


<img src="directory/directory/sample/imagename.jpeg">

In each row .

Hope you understand . Thank you .

snb
05-11-2013, 02:03 AM
I have about 200 offline web page HTML files.

Where ? what filenames ?

parscon
05-11-2013, 02:24 AM
i attcached the sample file .


if you check i have data like :



<tr class="Row-Column-9">
<td>
<p class="Basic-Paragraph"><span class="char-style-override-5">Ref No :</span><span class="char-style-override-5"><br /></span><span class="char-style-override-6">60100002</span><span class="char-style-override-5"><br /></span><span class="char-style-override-5">E-ECU</span><span class="char-style-override-7"></span></p>
</td>
<td>
<p class="Basic-Paragraph"><span class="char-style-override-5">SRP No :</span><span class="char-style-override-8"><br />E-00002</span><span class="char-style-override-8"><br /><br /></span><span class="char-style-override-5">Replaced No :</span><span class="char-style-override-8"><br />20577135</span></p>
</td>
<td>
<p class="Basic-Paragraph para-style-override-2"><span><img class="frame-8" src="3-Ok-F-web-resources/image/60100002-F_fmt.png" alt="60100002-F.jpg" /></span> </p>
</td>
<td>
<p class="Basic-Paragraph"><span class="char-style-override-9">Wheel Loaders:</span><span class="char-style-override-5"><br /></span><span class="char-style-override-5">L60E, L60E OR, L70E, L70E OR, L90E, L90E OR, L110E, L120E</span><span class="char-style-override-5"><br /></span><span class="char-style-override-9">Excavators:</span><span class="char-style-override-5"><br /></span><span class="char-style-override-5">EC160B LC, EC160B NLC, EC180B LC, EC210B F, EC210B FX, EC210B LC, EC210B LR, EC210B NC, EC210B NLC, EC240B FX, EC240B LC, EC240B LR, EC240B NLC, EC290B FX, EC290B LC, EC290B LR, EC290B NLC, EW145B, EW160B, EW180B, EW200B</span><span class="char-style-override-5"><br /></span><span class="char-style-override-9">Motor Graders:</span><span class="char-style-override-5"><br /></span><span class="char-style-override-5">G710B, G720B, G726B, G730B, G740B, G746B, G780B</span></p>
</td>
</tr>



i need a code extract the name of image file .

resualt will be : 60100002-F_fmt.png


if it is not possible extract just the image link like :



<img class="frame-8" src="3-Ok-F-web-resources/image/60100002-F_fmt.png" alt="60100002-F.jpg" />


Thank you .