extract all url

  1. T

    Extract data a URL and create pivot table

    Hi guys, New to excel macros, but having seen a couple of vids on You Tube I'm quickly becoming fascinated by its potential! So anyway, there's a task a run every morning and I think a macro could help but i'm hitting huddles. Wonder if anyone can help? The task 1 - Take 2 csv downloads...
  2. M

    Extracting data from website source code

    I would appreciate if any super experts would help to find a solution to extract source code data from a chart found on a website and build a macro to automatically import the data to excel. The website's source code is from: Load Forecast vs. Actual: Current Day The data to extract is the...
  3. A

    Extract actual addresses from hyperlinks with User Defined Function

    I have the following code in my excel module and when I typein this formula =GetURL(A2) (A2 is the cell that the hyperlink in), and press Enter button to see real hidden hyperlink, get the error #NAME? <code class="vb keyword" style="white-space: nowrap; padding: 0px !important; font-family...
  4. D

    Extract links from cells of an entire column

    Hello guys, I have a column with cells containing html code with various tags, text and various links. Somewhere in these cells there are some hyperlinks of various length from a specific domains The format of the urls are http://www then followed by a random number, then a specific domain and...
  5. M

    Need Macro vba to extract only URL string from a column having strings with some text plus URL

    Hello Experts. I just started learning about VBA and got below problem. In below example, column A is a huge set of cells that has strings with URLs in it. I need to extract only URL starting from "http" keyword. There are no cases when this string has more than one URL. I searched internet...
  6. T

    extract all url from a website

    Hi, I need to copy the information of all the products of this website: http://www.selleckchem.com/ but I don't know the url for each individual product. So I need to extract all the url related to the products into excel. Does anyone know how it can be done? Many Thanks,

Watch MrExcel Video

This Week's Hot Topics

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
Top