Automating Excel with Javascript
Automating Excel with Javascript
  • 3
  • 4 004
A walkthrough of using the JavaScript Automation Development Environment (JADE) add-in for Excel.
JADE allows you to automate your Excel workflows using JavaScript. Save your code in non-macro-enabled workbook files!
More details and the codes you need to follow along are at blog.jsvba.com/2021/12/a-walk-through-of-using-jade.html
Переглядів: 2 788

Відео

Installing the JavaScript Automation Development Environment (JADE) on Excel Online
Переглядів 8162 роки тому
This video just shows how to install JADE, an add-in for Excel Online that allows you to automate your workflow using JavaScript as a replacement for VBA. More information at the blog: blog.jsvba.com/2021/12/introduction.html
Installing the JavaScript Automation Development Environment (JADE) on Office 365 for Windows
Переглядів 4002 роки тому
This video just shows how to install JADE, an add-in for Excel that allows you to automate your workflow using JavaScript as a replacement for VBA. More information at the blog: blog.jsvba.com/2021/12/introduction.html

КОМЕНТАРІ

  • @jean-benoistbrault1549
    @jean-benoistbrault1549 2 роки тому

    Nice !!! i've been trying JADE but i have some questions: Can you delete a module ? can you call functions from a module A into a module B ?

  • @flance4011
    @flance4011 2 роки тому

    Will this allow office script codes or typescript codes?

  • @flance4011
    @flance4011 2 роки тому

    very nice. I have a few questions: 1, Can this do all the operations that the VBA code does? 2. It will be very usefull if you target the different areas that a VBA code operates and demonstrate here, what the alternative would look like with js. 3. How do you target specific cells, do varous loops, deal with arrays, collections, dictionaries ? 3. where to find other GIST IDs?

  • @EngineeringFun
    @EngineeringFun 2 роки тому

    I cannot see JADE in my installation list. What do I do? Thanks.

  • @EngineeringFun
    @EngineeringFun 2 роки тому

    I cannot see the jade option on my 365 on PC.