Is it possible in vbscript to edit Excel 2003 toolbar settings ?

Posted on 2007-07-25
Last Modified: 2013-11-14
When I capture with Wise the addition of an add-in via Excel,  a toolbar is added and the following files are added  to the msi file.
Windows\Profiles\Application Data\Microsoft\Excel\excel11.xlb
Windows\Profiles\Application Data\Microsoft\Forms\MSComctlLib.exd
Windows\Profiles\Application Data\Microsoft\Office\Excel11.pip
Windows\Profiles\Application Data\Microsoft\Office\VB11.pip

Is it possible to edit these files instead of replacing them on the destination system.   I want to avoid replacing settings that the user customised on his/or her system.
Question by:itbabe
    1 Comment
    LVL 19

    Accepted Solution

    You cannot edit these files directly as they are binary files containing data serialised by Excel itself.

    If you want to avoid replacing these files, you could run a custom action in your MSI to copy the existing files to some temporary directory, then copy them back at the end of the install.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Article by: Martin
    Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
    This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
    Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now