vba & web

I am trying to access an api from a site called keepa.com. I create a Msxml2.ServerXMLHTTP object and am able to get a response but the text is just a jumbled mess. For example the some of the response looks like this : I have tried to use MSXML2.XMLHTTP instead but I get an error saying that...

Hi, My goal is to Fill web forms using dynamic data which is stored in excel table. The proccess should look like the below: Go to link stored in "A"i Fill the given fields in web form using data from "A"i to "G"i Click "save" Wait 5 seconds Populate column "H"i with text: "Created" Repeat...

Hi, on an internal web which only runs in IE or GC there is a button with id="ext-eng-123" where 123 is a set of 3 numbers that change everytime the page is clicked. It appears it is a set of up to maybe 20 different combination, so not many. The whole line reads: <td align="left"...

Hi there I have a spreadsheet with a stock ticker in A2. Let’s say for example "GRMN" which is Garmin's stock ticker. I want some code which will go to the webpage www.optionslam.com/earnings/stocks/”STOCKTICKER”. So in my example this would be: https://www.optionslam.com/earnings/stocks/GRMN...

Hey guys, I'm trying to select a specific value (Month to Month) in combobox in an IE. Here is the HTML code in website: <select name="agreementTerm" id="agreementTerm" style="display: none;"> <option value="-1"></option> <option value="9">Month to Month</option> <option value="10">2 year...

Hi guys, I have an Excel file with defined macros that are opening specific PPT files. I'm looking for a VBA code that will run a specific macro based on if certain cells are empty and other are not. For example: If cells B1 and B2 are empty but cell B3 isn't --> then run Macro1 If cells B1...

I want to click a href link that is dynamic.I have really very little clue as to what am i doing, as i have little knowledge of programing(still doing VBA tutorials).I am not sure if it can be done with VBA or i need JAVA(of which i know almost zero). A push in the right direction would be...

Hi, I am writing the excel vba code for Login functionality. Somehow i have searched this forum and written the code. But i am getting "Automation error: Unspecified error". Please help me to resolve this . When i do debug the yellow marker show the line "Set doc = IE.Document " which is red...

Hello All, I am very new to this and I have been taking bits and pieced of codes that I have either found online or on youtube. [+>[SCROOLL TO BOTTOM FOR QUESTION]<+] I want to collect emails from this website: The State Bar of California Home Page I have automated the process to click and...

Hi, I am still new to excel vba and I am asking for your help. I have tried to query soccer league tables for different leagues but I don't know how to use loops. I want to query tables for different leagues (those with home and away) and put then on another sheet one after the other(skip one...

I have found some VBA code, which works fine, that when I run the code from a workbook, it opens all the workbooks from a designated file. For example, workbook A macro opens workbooks B, C, D, E... and then closes it again. My problem is that each of the workbooks has external data that needs...

Hi, I'm using IE version 9 and trying to click "submit" button using VBA. I've tried many ways but getting no luck. Can anyone please help? below is the element code of button. Please note that "on click" doesn't have space in real codes. <input type = submit value = " Submit " on click=...

hello i want to make e code for downloading files from web with scheduled time, i want to get the links form the sheet A1:A5, and the files to be named from B1:B5, and download time between links to be 5 mins . I tried to make some code but it only download the firs link, naming dont work as i...

I am trying take values from excel to web app here is the code. it is not working. I am attaching the source code of the html How can i automate excel to web application Option ExplicitSub SubmitToWeb()Dim rw As Long, ws As WorksheetDim IE As ObjectApplication.ScreenUpdating = False Set...

I appreciate if someone can advice how to convert the below windows code to work under Mac Machine as well , as it is works perfectly on Windows but not on MAC machine Public Function giveMeValue(ByVal link As Variant) As Variant Set htm = CreateObject("htmlFile")...

Hello, I have an online database that I need to access data from. I've gotten as far as logging in and I'm at the page where I need to select the type of report I need. I would select if from a drop down list that contains 5 selections for different types of reports. I've tried using...

I WANT TO NAVIGATE TO A PAGE OF A WEBSITE BUT THE HTML IS DYNAMIC THEN I WANT TO CONVERT THE CHARACTERS IN THE HTML AND REPLACE THEM BY THE HEX Here is the charaters i want to replace it is a tab ! " # $ % & ' ( ) * + , - . / here is the characters i want to have instead 21% 22% 23% 24% 25% 26%...

Hi Guys, I would like to write a macro to download information related to 579 companies mentioned as exhibitors URL: Event Map Could some one help plz

Hi, I am strugling with writing a macro that will get the data from web. Ex website I need to get number of all properties the one in orange. You found 67,158 properties for...