myurl

  1. J

    VBA - How to convert JSON to Table ?

    Hi, i have the following which loads a webpage and extracts the JSON Sub JSON1() Dim username As String, password As String username = "xxx" password = "xxx" Dim xmlhttp As Object, myurl As String Set xmlhttp = CreateObject("MSXML2.serverXMLHTTP") myurl = Range("C1")...
  2. 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...
  3. J

    Help not getting value from cell E20

    Hi, I have the code below to log in to website automatically by getting username, password from cells in a spreadsheet, problem having is that when click and goes to website filled in the password in the box from cell F20 but not in the Login box that should get it from cell E20 (The line in...
  4. T

    Inout text in Field - Excel VBA HTML

    I cant seem to work out how to input text into the text field, when inspecting the element in google it gives me: <input> class="gwt-Textbox" type="text" size="35"> current code im using is: im htmldoc As HTMLDocument Dim IE As InternetExplorer Dim myhtml_element As IHTMLElement Dim...
  5. D

    saving file not working from web site

    Dim myURL As String myURL = "http://test/Fxrates.xlsx" Dim HttpReq As Object Set HttpReq = CreateObject("Microsoft.XMLHTTP") HttpReq.Open "GET", myURL, False, "username", "password" HttpReq.send myURL = HttpReq.responseBody If HttpReq.Status = 200 Then Set oStrm =...
  6. H

    XMLHTTP60 can get text but not XML

    Hello all, I am trying to fetch XML data from a web site. I manage to access the data as text, and I wrote a function to parse it (very lengthy). I found that you can getElementsByTagName but this is not working for me. Here is my code: Private Sub GetPredictItData() Dim Req As New...
  7. M

    VBA MSXML2.XMLHTTP60 put in array or variable

    Hi everybody, Hopefully there is someone that can help me with the following. Below code will pass the responsetext in a msg box. I need the GUID from that responsetext and put that in a variable. Anybody a suggestion here? I saw a number of threads on passing this to a dictionary but I simply...
  8. S

    VBA Script to select the file and upload on IE

    Hi All i am trying to create a script to upload a wallpaper after signing. So far got through this after several attempts, your help is greatly appreciated. Source: Upload Upload current code Dim HTMLDoc As HTMLDocumentDim MyBrowser As InternetExplorer Sub VCW() Dim MyHTML_Element...
  9. E

    Macro from personal Workbook not working

    I have a macro to log into my e-mail automatically which works perfectly if it is in its own workbook. Once I transfer it to my personal workbook it generates an error each time I try to run it. "Compile error: User-defined type not defined" and highlights "HTMLDoc As HTMLDocument" in blue and...
  10. E

    VBA auto login with Chrome

    I found and modified a code that will let me automatically log into the site I want but I can't figure out how to change from IE to Chrome. please help Sub wisdomone() Dim HTMLDoc As HTMLDocument Dim MyBrowser As InternetExplorer Dim Myhtml_Element As IHTMLElement Dim MyURL As String On Error...
  11. P

    How to save PDF from link or manipulate Adobe

    Hi guys, As starts with the link I have (it won't work for you but it's not important)...
  12. B

    VBA Code to login into a Website

    Hey guys! I need to have my VBA macro enter the user name and pasword to login a website. I have read a number of posts related to this topic, tried a number of different methods and still can't get it to work. Dim HTMLDoc As HTMLDocumentDim MyBrowser As InternetExplorer Sub RepsolLogin()...
  13. N

    How to navigate number of urls from the list with delay of 1 minute

    Hi, Could anyone please help me in this task i am working on. I am looking to navigate url from the list one by one with certain delay of time let's say 1 minute. I tried this code below it opened url but not the way I would like it to be. Dim HTMLDoc As HTMLDocumentDim MyBrowser As...
  14. Y

    Arrays, Ranges and unknown row count

    I've created a macro that takes a list of addresses and returns the distance. The problem I'm having is that the macro is static, but I don't know how many rows of addresses I'm going to have. I've made it so that the data is returned in an array but once again when populating the column for...
  15. Y

    Arrays, Ranges and unknown row count

    Afternoon all, I've been doing a lot more VBA scripting so I thought I would join to get expert help and hopefully give one day. I've created a macro tha that will use the mapquest api to find the distance between two points. The macro works but I need to make it more dynamic. The main problem...
  16. S

    Help submitting log in info

    Hello! I am trying to write a macro and the first thing I need to do is log in to a website. It appears that I am able to have the macro open up the website, enter the username and password but I'm struggling with getting it to submit. Can someone tell me what I'm missing here? Dim HTMLDoc As...
  17. B

    Log onto Website via VBA

    Hi I have the below code, it opens the website www.reece.com.au/myaccount/login, but does not fill in the email and password (Correct information on code has been removed for privacy) I assume it is not working as I have not referenced the correct name in HTML. I assume it is email and...
  18. D

    Signing into Gmail Account using VBA

    Hi There, I am trying to automate signing into Gmail account using VBA. I have the code, the issue I'm facing is it takes the username, hits the Next button but does not take the Password, throws an error. Tried the same code with facebook.com and it works fine. For the password field I'm using...
  19. F

    VBA IE Website Automation

    Hi Experts, I am trying very hard since last few weeks but not able to automate website login through VBA. Using below stated code. It opens URL but User_Name and Password fields never populated. I am using below pasted code taken from google help pages. Dim HTMLDoc As HTMLDocument Dim...

Some videos you may like

This Week's Hot Topics

Top