Save webpage in Excel like firefox

Vergez

New Member
Joined
Dec 29, 2009
Messages
1
Hi everyone,

After 2 days, I give up ... and I come to you ... :)

In fact, I need to export a lot of webpages to excel, but only for the urls inside them ... urls which are behind an hyperlink and those which are not coded in html (inside a 'pre' code by exemple). I've found some macro to do the one or the other but not the both at the same time.

And I found that Firefox propose a "save as" exactly as I need. It export only the visible text and propose after into braklet the true url for each hyperlink.

Have you seen a similar code which can help me?

A lot of of thanks !!!
Vergez
<div_prefs id="div_prefs"></div_prefs><div_prefs id="div_prefs"></div_prefs><div_prefs id="div_prefs"></div_prefs><div_prefs id="div_prefs"></div_prefs>
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,214,929
Messages
6,122,315
Members
449,081
Latest member
tanurai

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top