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,

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...