1. MikeMcCollister

    VBA to Office Scripts

    I hear that eventually Excel will use Office Scripts, which is based on JavaScript. From my research this is only as a preview on the web version of Excel. Will this eventually be available for the desktop version of Excel? Has anyone started to use this? Will there be a means to convert...
  2. B

    Best Java Script Help Forum

    Does anyone know of a good Java Script forum thats as good as Mr.Excel? Ive got to start learning how to add some script to some pdfs and need help.
  3. H

    PDF Manipulation in VBA

    This my be outside the scope of this messageboard. I have a number of automation processes running many reports and such. One of the tasks that needs to be done is to save an word file as a PDF. This is, of course, trivial in VBA. However... What I really need to do is use Acrobat DC ability...
  4. E

    VBA to Javascript

    Hej Guys. I made a little VBA-script i now i need it translated to Java script. I made it in excel and now i need to use it in google sheets. The VBA code is this: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim B As Range: Set B = Range("B:B") Dim v As String...
  5. A

    Javascript to VBA

    Hi Everyone, I coded this following in adobe PDF using java script and I would now like to convert it into excel. Could you please help me with trying to convert this following code into VBA? if (event.value == "Distribution") { var cost = Number(this.getField("cost...
  6. R

    Javascript to VBA

    Is there a way to convert Javascript to VBA without recoding from scratch?
  7. K

    Website not updating after inserting drop down option via VBA

    I've tired a lot of different approaches and still have not figured out any way to overcome the issue. When use the .selectedindex = 10, the option appears just like i wont it to, but the date range boxes will not appear after i've picked the option. ive tired .focus .fireevents .click and many...
  8. K

    JavaScript must be enabled in order to view this page

    Hi there, I use Excel web query to get data from the web page. Sometimes the query works but on occasion, it returns nothing but the phrase in the title. I checked both my chrome and IE browsers, Javascript has been enabled in both of them. Url in question...
  9. 4

    VBA: Select value from html dropdown

    Hi, I come across a very challenging task that I can't find a way to accomplish. The goal is to to fill/ choose value from a drop down list which I suspect has a Java script applied on it which not allowing me to easy choose value by id. I manage to type in the value in the search bar, mimc...
  10. D

    Javascript errors and how to deal with them

    I am just starting with JavaScript in Excel, and I have downloaded the "Excel JavaScript UDFS" book from this site. I have installed the sample add-in, but I have a problem with the RangeAverage function: With a large range (e.g. 1 column x >500,000 rows) it returns #NA #. After returning this...
  11. I

    Inserting user ID and password

    Hi Guys, I've been trying to auto certain processes and i'm trying to automatically login to a certain website. Below is my VBA code and the java script of the website. Until the line when its suppose to insert the userid and password, an error appeared. Appreciate any advise <form...
  12. K

    Internet Explorer webpage - login and password

    Hello, I have a website, for which I would like to write a macro for providing username and password, and log in with specific credentials. The website is written in JavaScript language. I am using MS Excel 2016, IE v11. Here is my current code (I needed to provide "xxx" where necessary): Sub...
  13. H

    javascript THIS in vba

    Hello Is there an equivalent function in VBA as THIS in javascript? Regards
  14. M

    Get URL from website

    Hello, I have a trouble with getting URL from the website: 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...
  15. R

    Help with website

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

    How to get multiple pages of live data from javascript website

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

    Scraping from Javascript rendered web page

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

    VBA Selenium

    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]);"...
  19. T

    Use VBA to export CSV from webpage

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

Some videos you may like

This Week's Hot Topics