javascript

  1. N

    VBA to Javascript

    Is anyone here a whiz or genius at both VBA and JavaScript? We are looking to move a certain important document to Google Sheets which contains a hideous amount of VBA for the macros within it, in order to simplify things (they search for very certain information across various ranges of data)...
  2. J

    Webscraping Grocery Website

    Hi There, I'm having a lot of trouble trying to get a simple webscrape to work. I am using a dynamic URL to search for a product (in this case 'GREENE KING ABBOT ALE') and what I'd like to do is have all the available links that return from the site to appear in column A of sheet called 'Single'...
  3. S

    How to trigger a webpage datepicker when doing web scraping?

    Hello, I'm trying to scrape what is known as the ' Yield calculation price' of a listed fixed income instrument. In order to get the right series, I have to set both a from and to date. These can be set by submitting the values to datepickers on the site, but the table underneath with the...
  4. 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...
  5. 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.
  6. 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...
  7. 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...
  8. 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...
  9. R

    Javascript to VBA

    Is there a way to convert Javascript to VBA without recoding from scratch?
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. H

    javascript THIS in vba

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

    Get URL from website

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top