myurl

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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