xmlhttp

Hi, i am experimenting with the following: Sub testXMLHTTP_VBA()Dim xmlhttp As Object, myurl As String Set xmlhttp = CreateObject("MSXML2.serverXMLHTTP") myurl = "https://www.mrexcel.com/forum/excel-questions/" xmlhttp.Open "GET", myurl, False xmlhttp.Send MsgBox (xmlhttp.responseText) End...

I have made a scraper using vba xmhttp method which is parsing yell.com very smoothly at this moment.However, I noticed that the site sometimes uses a redirection method.As a result I end up with nothing returned when I run the code.So if there is somebody out here that can help me create this...

Question: I'm looking for ideas or methods on how to handle a child window opened by a JavaScript function on a .aspx webpage. I've run down every rabbit hole I can find and hit a road block each time. The problem: I have a website that creates orders and part of the webpage requires a...

Hello Experts,I have a query, i am currently trying to do an automation with XML in excel sheet.I am trying to login to a website by using the below XML query. The website has four important fields which gets authenticated by verifying all four fields i.e., Usename, Password, Type and Empcode...

Good Afternoon, I have been trying to no avail to get a VBA script to tunnel to my corporate reports viewer which is ASP I believe, choose a drop down choice, enter in a SKU and run the query. I have been able to successfully do it when I have VBA launch and IE window for me, but that process...

Hi, How Can I get the data from google result, it's like in this example, but not only first result also alt least 10 or 20 first results. Sub XMLHTTP() Dim url As String, lastRow As Long Dim XMLHTTP As Object, html As Object, objResultDiv As Object, objH3 As Object, link As Object...

I upgraded to windows 10 today and I thought I may like it until I tried running my programmes coded in Excel 2007 VBA. First of all I found I could not save a file to C:\ for some reason VBA was trying to add a random number after c:\ After changing the path to users\documents I then tried...

I am developing a tool to assist my sales team in the quotation process. Majority of our quotation is done in Excel, as part of when the quote is generated it saves the quote as a PDF and I would like it to automatically upload all the quote data and a copy of the PDF to our CRM package using...

Hi All, Multiple time a day i go to a URL and fill in an HTML form, hit export and this automatically starts downloading an Excel spreadsheet (Chrome). I want to automate my queries to this web service and have tried without success. Using Google Chrome development tools I have identified the...

Sub GetCSV() Const strFilename = "MINUTE.csv" Dim wshList As Worksheet Dim wshTarget As Worksheet Dim r As Long Dim m As Long Dim objXML As Object Dim f As Long Dim arrResp() As Byte Dim strWebfile As String Dim strLocalFile As String Dim strIP As...

Hello All, I am trying to send a SOAP request to a webservice from VBA, But i always get http400/BAD request error. I tried a lot resolve this issue but it doesnt seem to work at all, not sure what could be wrong, kindly help me please

I am using xml in VBA. The code below adds an item to a shopping cart on a remote website (posts a form). Then the code displays the result in Internet Explorer. You can see in the response there is a "get estimates" button. I need to automatically click that, enter location info, and get the...

I'm using XMLHTTP to grab the source from various pages so that I can extract links and information from them. I've encountered a case where the information I need is buried inside the head block of the page, inside a script tag. When I examine the string loaded into the xmlhttp's...

I'm trying to extract data from some webpages. I'm pulling in the html with an XMLHTTP object and extracting the desired information with Regex. The following code works fine for vanilla ".html" pages: Dim pageHTML As String Dim oXMLHTTP As Object Set oXMLHTTP =...

I need help trying to retrieve the source code from a website. How I normally navigate there: I start at http://www.bls.gov/home.htm, scroll over Subject Areas, click Consumer Price Index, click Top Picks button for All Urban Consumers database (probably have to scroll down a little), check...

I'm having a problem downloading data when the website uses foreign or special characters. In this case "Rübæus" Here is my code: Dim xmlhttp As New MSXML2.XMLHTTP50 Dim text1 As String xmlhttp.Open "GET", "http://beeradvocate.com/beer/profile/1199/23474", False xmlhttp.send text1 =...

I am doing some automation of getting stock data and doing my own analysis... however, I cannot get some of the webpage data using QUERY TOOL, possibly maybe becoz the data is generated by javascript (in fact I m not very familiar with programming) I heard that XMLHTTP can be used to get data...

I would like to get some data such as historical stock price from the web. 1. What are the criteria to use the 3 function? 2. which method is the best to use? 3. website example: http://www.quamnet.com/quote.action?quoteSectionCode=pastprices&stockCode=2345...

I am trying to upload an image to twitpic using VBA from Excel or Powerpoint using the twitpic API. http://twitpic.com/api.do I have tried all kinds of combinations but am getting stuck. I keep getting the message errcode="1001" msg="Invalid Twitter username or password" as the xml back I...