Hi all again!
I'm busy, you see :)
Now I've got a deal with an Excel Toolbar and it's creation.
This Application (repackaged) creates an Excel toolbar, but the repackager only recognizes the change made in the Excel11.xlb (toolbar config file in userprofile).
The problem is :
- I can overwrite the target system's Excel11.xlb with this one in the new package, but doing that means deleting any previos configuration of each user. So I must find an alternative way to create the toolbar (and disable it) with NO .XLA FILE (sorry but there's no .xla file).

And that's it!

kss KrisBcn
0 Comments   [ - ] Hide Comments


Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity


Can you view the file structure of .xlb file?
I know Client Access uses .ini file structures extensively to store settings - you may design your vector of attack around that...
Answered 08/22/2006 by: revizor
Third Degree Blue Belt

Please log in to comment
Hi Revizor,
The .xlb file structure is not viewable for me, and the .ini file the package has is a setup.ini that doesn't have any entry for the toolbar...

Answered 08/23/2006 by: KrisBcn
Purple Belt

Please log in to comment
Hi Kris,
the only SW which can edit the xlb-file is this one (afaik):
Unfortunately, the website is only in german (maybe bablefish is a help...)
Regards, Nick
Answered 08/23/2006 by: nheim
Tenth Degree Black Belt

Please log in to comment
Well, thanks to all,
I've finally done a script as custom action to add the addin with the excel.application object.
Answered 08/31/2006 by: KrisBcn
Purple Belt

Please log in to comment
Hey krisBCn,

Is it possible for you to share the details of that script?

Answered 10/16/2006 by: islander222
Senior Yellow Belt

Please log in to comment
Hi Adrian
on error resume next
strPath = Session.Property ("ProgramFilesFolder")
Set objExcel = CreateObject("Excel.Application")
objExcel.Addins.Add(strPath & "IBM\Client Access\Shared\cwbtfxla.xll").Installed = True
With objExcel
.CommandBars("iSeries Access").Enabled = True
.CommandBars("iSeries Access").Visible = True
.CommandBars("Worksheet Menu Bar").Enabled = True
End With
set objExcel = nothing

I hope it helps you
Answered 10/16/2006 by: KrisBcn
Purple Belt

Please log in to comment