Posts

Showing posts with the label groovy grails scriptom netbeans java plugin scripting script word excel automate com server vba iexplore internet explorer activex build howto tutorial diy jacob

Excel Add-In Script

This was originally created to register the iSeries Client Access Add-In with a workstation, although it could be used for other Add-Ins as well, just replace the "path" variable. This assumes the Add-In is a 32-bit Add-In.  Not sure how this will behave with 64-bit Office, so please post your success or modifications. To use, just save this as "Register Excel Add-In.vbs" and double-click.  To suppress dialogs, run from command line with "cscript.exe". -Tres ' Registers an Excel Plugin. ' Note: Run this script with cscript.exe to suppress dialogs ' Created 2/17/2011, Tres Finocchiaro ' Updated 6/21/2011, Tres Finocchiaro (64bit support, Reinstall support) Option Explicit ' Uncomment this next line to suppress error messages 'On Error Resume Next Dim xl, addin, shell, path, i, a, dll, is64,  path32, path64 ' The path of the plugin.  This is safe to change path = "%PROGRAMFILES%\IBM\Client Access\Shared\cwbtf...

A Groovy Way to Start Programming - Getting Started With Scriptom in NetBeans 6

Image
Scriptom + Netbeans Quickstart Guide Needed: (Download all of these before beginning) [ download ] [ site ] Netbeans -Java 6.0 Development (with Groovy support) ~50MB [ download ] [ site ] Groovy 1.1 or higher (zip file) ~20MB [ download ] [ site ] Scriptom 1.5 or higher ~3MB [ download ] [ site ] Jacob 1.14 or higher ~0.5MB Instructions: Download all files above. Extract Netbeans-Java to Deskop in a folder called "netbeans" Inside this folder (where LISCENSE.TXT is), create a new folder "lib" . Extract Groovy 1.X/ embeddable/ groovy-all-1.x.jar to Desktop\netbeans\lib. (the "lib" folder you just created) Open Scriptom-2.x.zip and extract Scriptom-2.X.jar to Desktop\netbeans\lib . Open jacob_1.x.zip and extract jacob.jar to Desktop\netbeans\lib . (When prompted to overwrite, click YES) Extract jacob.dll to Desktop . (Most people can use the version in the x86 folder) Navigate to Desktop\netbeans\bin, and right click netbeans.exe >> Send ...