Posts

Showing posts from June, 2011

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