Stuntace
Sat Jan 08 14:51:06 CST 2005
That's it !. Thanks Sakuda!. I looked all over for a Q doc, I knew they
must of had somthing at MS, but I coulnd not find it.
I will try your code suggestion, It looks good.
Thanks again
"y sakuda" wrote:
> "Stuntace" <Stuntace@discussions.microsoft.com> wrote in message news:17241368-D539-4454-ABBA-868F5618B411@microsoft.com...
> > I'm trying to script an add-in install for Excel 2003 (source addin = .xla
> > file). I can't seem to find where or if this info is stored in the REG (XP).
> > I know VBS can copy/write the info.... but to where?... . Any ideas ?.
> > Ty
>
> How To Install an Excel Add-In (XLA or XLL) with Automation
>
http://support.microsoft.com/default.aspx?scid=kb;en-us;280290
>
> I remake and use that like this.
>
> Dim oXL, oAddin
> dim Args
> set Args=wscript.arguments
> if args.count=0 then
> wscript.echo "Drag and Drop xla file to Icon"
> wscript.quit
> end if
> Set oXL = CreateObject("Excel.Application")
> oXL.Workbooks.Add
> Set oAddin = oXL.AddIns.Add(args(0), True)
> oAddin.Installed = True
> wscript.echo "End"
> oXL.Quit
> Set oXL = Nothing
>
> Y Sakuda from JPN
>
>