javascript

Hello, I have a trouble with getting URL from the website: https://searchbzp.uzp.gov.pl/Search.aspx On this website there is a table. The text "Zobacz" within the table is a hyperlink and from this place I want to get URL. I can click on this url using below code, and then browser trying to open...

I am trying to first change the value of an item in a drop down and then select it. This Page will load the list after the page originally loads. The Option click seems to be called by JavaScript I can use Chrome or Firefox to inspect element and then change the value from 100 to 11000 and then...

Hey! I need to extract data from a website, but the data on it has a limit of 99 rows of data per page, and so i need to get data from multiple pages. The website requires credentials, and i have my own secured credentials for work. Using Excel's "Get data from Web" option, the data is pulled...

Hi mr excel comunity :) I wonder if anyone know how to handle pages that are generated from javascript. here is my basic code web scraper code: Sub Somesite() Dim XMLReq As New MSXML2.XMLHTTP60 Dim HTMLDoc As New MSHTML.HTMLDocument Dim HTMLRows As MSHTML.IHTMLElementCollection Dim URL As...

I am unable to find the proper syntax for passing an argument to a JavaScript function in Excel using the Selenium VBA wrapper. What I show below works with VB.NET, but does not work with VBA. driver.ExecuteScript ("document.getElementById('ctl00_Content_lblSepID').innerHTML = (arguments[0]);"...

Hi, I'm using VBA to access a webpage and run a report that requires user defined fields. After the report generates on the website, I want to export CSV. The website is a SQL server site that contains pre-built queries for non-coders. I successfully wrote code below that takes me to the...

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

<tbody style="margin: 0px; padding: 0px; border: 0px;"> 1down votefavorite1 I need to select an option from a javascript dropdown menu on IE with VBA, as the tittle says. In the code below, I have to select the option "SAO1636 - SAOJJ231C - Kontik Franstur" (Option value = "279-32") The HTML...

I would like to download a webpage data,which was triggered by JavaScript onchage function. The problem is how to wait for the changeof webpage (triggered by JavaScript onchage function) completed updated before I can retrieve the data using my VBA code. Webpage...

I want to generate a javascript file containing data from a range on a sheet. I need to call this javascript file in an HTML file so it displays the excel data in an HTML table. The table will display live data from the spreadsheet. Here's my code so far which produces the js file Sub...

I have written a macro that sends text from excel to an input box on a website to be used as for a search. The code works fine for other textboxes, however this textbox is giving me issues. It seems that it is inserting the text as a input mask instead of the actual value. Here is my VBA code...

Ciao a tutti Ho un problema vorrei scrivere uno script vba per copiare alcuni dati da una tabella in questo sito: http://www.ecb.europa.eu/stats/money/yc/html/index.en i dati non sono visibili subito ma bisogna selezionare il tag "Yields" in alto a destra rispetto al grafico. a quel punto...

I am trying to pass a recordset to an HTML javascript. The reason is that my company's web page sercurity policy does not allow me to create an "ActiveXObject" in javascript. I was experimenting with passing a recordset from VBA to HTML javascript function as a work around. I can't seem to...

I've written an Excel VBA macro to paste some data into an AngularJS form -- it opens an Internet Explorer (11) window, navigates to the page containing the form, and crawls the document tree looking for certain elements by their ID, changing their values from blank to non-blank strings from the...

I created a webpage that I need to render in a Web Browser hosted on a User Form in excel. When I launch the User Form the page loads great but the JavaScript doesn't seem to be working. I saved the contents to a text file and launched it in IE. I noticed that there was a warning at the bottom...

Hi There, I need to submit one form & then submit a second form that only appears after the first is submitted. How do I refocus the .document reference to bring in the new objects created after submitting form 1? Code is below, along w/ a list of all reference libraries I'm using...

Hi There, Been struggling w/ this code for a week or so now. Essentially, what I want to do is click on/fire the JavaScript link that shows up in form(2) (coach's Last Name, First Name) after pressing Submit on the button on form(0). However, VBA doesn't seem to be recognizing form(2) at all...

All of this code works like a charm, except for the following: iWorkbook.Sheets("testSheet").Move + " After:=" + iWorkbook.Sheets(2); How do I code the Move function with JavaScript? I've tried fixing the spacing, the correct object appears to be in operation. Many, many thanks for your...

This is a long shot I'm sure but i'm writing a query for a website that places the table content via javascript. so if i go the page the data isnt there until you fill out the form. Anyway. I got the url that will work with the parameters i need but excel will not import the javascript table...

Hello guys! Could you please give me any tips on how to extract the data on this site Market data | Nord Pool Spot to excel 2010? The table is dynamic and updates every hour so I want the new data be imported to excel aswell. many thanks Mikael