url

Hello everybody. I'm a newbie by surfing the net via GET and POST request. So far, I've had no many problems in scraping data from a link. Sub getintoSITE() Dim URL As String, strResponse As String Dim objHTTP As Object URL = "............" Set objHTTP =...

greetings i am trying to send out sms using an api http://bulksms.mysmsmantra.com:8080/WebSMS/SMSAPI.jsp?username=username&password=password&sendername=sender id&mobileno=919999999999&message=Hello i want to get the mobileno from a cell in sheet7 of the workbook from "d" the cursor will be in...

Hi, I've looked all over for a solution to this but nothing. I'm trying to pass a number as a parameter into a URL, keeping the leading zero's. Example: 000129832 When I enter this it gets passed as 129832 which doesn't work in the URL I have this: let SR=(ACNUM)=> let Source...

Hi For the first part my code works fine, it does what it is meant to do. 1) I place a search item in Sheet2 Cell A1 e.g. "Laptops" and it opens Google and extracts all the url for laptops 2) It paginates to the next page, for which I have set to 5 pages, so URL from all 5 pages are...

I have a vba code that extracts ebay product details the code works fine if i am using a direct url in the code Original Code for search, but only searches 1 item .Navigate2 "https://www.ebay.co.uk/sch/i.html?_from=R40&_trksid=m570.l1313&_nkw=jackets&_sacat=0" This variation of the...

Hi In my workbook I have two sheets Sheet1 = "Scraper" Sheet2 = "Url List" In Sheet 2 Column "A" Row 2 I have a list of URLs, every time one has been processed my code place a NUMBER "1" in column B next blank row. The number "1" have two purposes, one as a counter and two to indicate that...

My code extracts emails from a website, this bit is fine It can also extract URLs from a site, the PROBLEM is that it extracts all LINKS and not just the domain name Also I can only extract one or the other, either emails on their own or Links, when what I want is for it to be something like...

Hi Experts, I need help on modified a VBA code below Sub Mail_small_Text_Outlook() Dim xOutApp As Object Dim xOutMail As Object Dim xMailBody As String Set xOutApp = CreateObject("Outlook.Application") Set xOutMail = xOutApp.CreateItem(0) xMailBody = "Dear All" &...

Hello, so I have a code to download a google sheet as excel to my computer. I'm getting the following error in my code and can't figure out what's wrong: (line highlighted in red) Sub ImportGoogleSheet() Dim URL, Location, FileName As String Dim objWeb, objWrite As Object URL = "Google...

I have a list of URLs on sheet2 "Url List" when my code runs it works it way through these URLs and the extracted date is placed in sheet1. Is there a way of skipping Urls with captcha? e.g. it times out and moves to next url if no data is extracted with X amount of secconds If this is...

I am working with the newest version of Excel / Office 2019 and am uncertain how to get an older workbook with VBA designed to pull multiple worksheets of data from a password protected site online. In the past, I was able to go to Data>From Web>enter URL and sign in>close window>run Macros>and...

I have a list of emails, I need to link them to the correct URLs. Problem is there are too many to do manual. I was hoping for some vba code that would MATCH part of the string in the EMAIL to that of the URL and place it in the next column/s Example Sheet1 column A has all the urls <tbody>...

Hi all, Been searching for hours into the wee morning about this but to no avail. I'm running a QueryTable (first time using this) to scrape some csv info from a webpage...then I format/clean the scraped data. This works on the first time, but not on the second/third/fourth, etc time. By...

Hi everyone! I've been trying to establish a data connection to an online JSON file. This seems to work just fine, but part of the URL is a date, like so: https://www.sampleurl.com/api/file.json?id=25&start=2019-01-01&limit=2500 I'd like to be able to have that date automatically be today's...

I have a macro on Sheet1(Sheet1.OpenCreative) assigned to an object that is referencing a cell with a dynamic hyperlink. When I duplicate this sheet, i would like the macro in sheet 2 to automatically change to Sheet2.OpenCreative. Is this possible? Macro code below: Sub OpenCreative() URL =...

So I have a wonderful piece of code that someone helped me put together. It downloads a file from a website (just a pdf from a cell-specified URL) and then time stamps it (so you can quickly download again for updates). It references cell A1 for the URL... and I have 5 pieces that download...

Hi All, Hope some of you clever folk can help me. I wanted to extract the number in the following URL, it is after the fifth "/", and before the "?": <colgroup><col width="87" style="width: 65pt;"></colgroup><tbody>...

Hello EVeryone, I was wondering if there is anyway or Formula to extract Video id from youtube url . For example below is url https://www.youtube.com/watch?v=Hc7BjYmn9z0 and video id is Hc7BjYmn9z0 Is there any formula that I can use? Thanks in advance.

Hi, i'm trying to write simple script to check webpage status. And i have a problem with feeding url address from active cell. Public Function GetServerResponse(url As String) As Integer On Error Resume Next With CreateObject("WinHttp.WinHttpRequest.5.1") .Open "GET", url...

Hello everyone, I try to figure out how to get a value (id) from a website url. I've created a table with 2 columns, name and id. I've filled the name column (95 rows) and try to get the id from the website url. The code below does function (i'm sure it could be done better, but i don't have...