urls

Hi guys I am trying to extract a set sequence of 12 numbers from various Ebay URL's. Here are a few working examples...

Hello, I need some help making a macro to extract table data from multiple pages of the same website (see example at...

Hi all, I have this excel spreadsheet that has a table with a list of url's on column T. These URLs lead to a very simple page with the button "Download a Copy", which allows me to download a pdf doc. I was wondering if it's possible to create a macro that goes into each cell with the URL...

Hi, Is is possible to add a cell reference for the text in a count ifs formula? Here is what I'm trying to do: I have 195,000 URL Links in one column, I have 2,000 unique URL's in the other column, the column that has 195,000 urls are duplicates of the original 2,000 URL.s For each URL, I...

Hello, I am very new to VBA, and trying to figure out how to pull stats on NFL players so that I can run analysis on these numbers. I first need to figure out how to create a URL for each player, and I know that there is a way to do this for the list of player names that I have in a column...

Hello - I have a spreadsheet of URLs, some of which contain IP addresses and some don't. I'm struggling to write an excel formula that will identify the URLs with IP addresses in them, and extract that IP address into another cell. What formula would I paste down column B to achieve this...

Column A contains urls, need vba module to download the images from these urls/hyperlinks to desktop. The below link has been converted to hyperlink in excel <tbody> http://i723.photobucket.com/albums/ww237/sukkhi2/Stock 23/Stock 23 Remaining/26ALPHAZ340_zpssoxAB3fbh.jpg </tbody>

I have a spreadsheet that I'm using to import data from a webpage. I've been able to pull in everything from the page but I'm looking for the information in a specific node. I'm having trouble pulling it in. Here's the info Site: https://leagueofcomicgeeks.com/profile/mauricem72/pull-list I'm...

Hey guys, I have a couple of URLs that contain the "origin?" text before the part I want to extract. For example: wwwXXXX.com/ie-de/origin=10_se_Display_native wwwXXXX.com/ia-de/de/origin=10_se_Display_on wwwXXXX.com/ia-it/de/origin=10_se_Display_off I want to create a new column containing...

Dear Forum, I was wondering if anyone could help me get to a solution to this issue. Basically on my excel sheet I have a list of URLs (not hyperlinked ie. clickable) all listed under Column G. Column G can only be populated with URLs from cell G4 to cell G104; however it might also contain...

Hi all, I am new here and I have one question, probably the most simple one ever but I got stuck. For hours I've been searching on the web but all answers are too complicated for what I want. I have a list of 50.000 urls in column A of the worksheet. All urls are the same structure and I...

Dear Excel Experts, I have list of URLs(Each urls have a Single IMAGE in a page)in the Excel spreadsheet like below. I would like to Save the each URL's in PDF format or Image in to Desktop or any path in to my system by USING chrome or Internet explorer.. A1 CELL URL1 URL2 URL3 . . . .URL1000...

I have data like this. <tbody> Google MSN </tbody> in above data google and msn are hyperlink with URLs. Now I want extract URLs in next cells, like below. <tbody> Google https://google.com (with formula) MSN https://msn.com </tbody> Is there any formula / macro or some...

Hi, I have a VBA script to open URLs from selected cells in excel. However it is opening each URL twice - any help to ensure it only opens one for each cell would be great. The VBA is: Sub OpenURLs() Dim myCells As Range, oneCell As Range Set myCells = Selection For Each...

Hello, I am new to forum and new to macros too. Is there anyone who can help me to extract data from so many URLs to excel file. Is it possible with macros??

I have a small query related to Excel Vb.I want macro which is get the value from Sheet1 in A section and open into internet explorer.when the page open it.It should copy the urls and paste into sheet2.if we have one or more value in sheet1 it should open all the urls and copy all the multiple...

Hi I have a table with three columns: A contains urls, B contains domains C contain domains like <tbody> A B C http://headjs.com/site/assets/ http://headjs.com https://www.w3schools.com https://www.w3schools.com/jsref/ https://www.google.de https://mein-trikotsatz.de...

Hi there I have this very useful formula: =HYPERLINK("\\server\CVs"&A5&" "&B5) which creates a hyperlink to a document file on a shared drive according to words in the spreadsheet. At the moment, this displays the whole hyperlink in the spreadsheet. Could someone advise what I need to add...

Hello, I have some cells with text. A part of each of these texts is an URL. But these URLs are not formatted as a link, you only see the absolute definition of the url. I know that if a cell contains an URL only, it is formatted as a link, but how do I do that when there is more text in the...

Hi, I have 2 questions. First, is it possible to use the script mentioned here: http://www.mrexcel.com/forum/excel-questions/381291-activating-hyperlinks-via-visual-basic-applications.html Sub Hyperlink() Shell "explorer.exe " & Range("J2").Text End Sub To activate a cell range? I.e could it...