1. J

    MSXML2.serverXMLHTTP : Adding Authentication + getting JSON

    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...
  2. S

    help Convert code from XMLhttp to WINhttp

    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...
  3. M

    VBA and HTML/JavaScript next step ideas

    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...
  4. A

    XML HTTP Post using VBA

    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...
  5. M

    xmlHttp Post in VBA from ASP Query?

    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...
  6. O

    GET data from Google Result

    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...
  7. R

    All my VBA 2007 Code fails running under Windows 10

    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...
  8. W

    Using XMLHTTP to upload a file to API

    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...
  9. D

    xmlHttp not returning any content - VBA

    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...
  10. V

    get csv from remote CE computer

    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...
  11. A

    using XML in VBA

    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
  12. E

    In VBA after automated xml form post, how can I automate interaction with the response?

    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...
  13. L

    XMLHTTP and javascript

    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...
  14. L

    XMLHTTP problems

    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 =...
  15. D

    Data Extraction from Website

    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...
  16. L

    Character error when using MSXML2

    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 =...
  17. C

    xmlhttp step-by-step instruction please

    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...
  18. C

    Querytable, XMLHTTP, WINhTTP?

    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...
  19. K

    Uploading an image via VBA

    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...

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