Distributing VBA with installshield 12

Posted on 2007-10-18
Last Modified: 2013-11-14
I'm looking for a walkthrough on distributing VBA 6.4 using Installshield 12 (Basic MSI installation).  I have read through the discussion in the SDK help file, but it is not clear to me how to get their setup.exe file to run under my .msi
Question by:ChemstationsDeveloper
    LVL 1

    Accepted Solution

    Here's how it works.

    the VBA 6 SDK provides its own setup.exe file, a setup.ini file and the following supplementals:


    and these optional files

    the trick here is to create an MSI as described by the VBA SDK, and and you run it with Microsoft's Setup.exe.  the setup .ini file is used to point setup.exe to your msi, as well as direct it to the locations of the VBAOF11.MSI and VBAOF11I.MSI (for multiple localizations you will need a VBAOF11n.MSI for each language (LCID)

    In your MSI, you might needs some of the optional msm's depending on the features you use.

    So the way it looks:

    Microsoft's Setup.EXE->
                                   Microsoft's optional .MSM's
                    Microsoft's VBAOF11.MSI->
                                    Microsoft's VBAOF11I.MSI

    make sense? :)

    LVL 1

    Expert Comment

    Additional Comment:  this comes directly from Microsoft's help system in the VBA6SDK ("Redistributing VBA") and From Summit Software's support team.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Here we come across an interesting topic of coding guidelines while designing automation test scripts. The scope of this article will not be limited to QTP but to an overall extent of using VB Scripting for automation projects. Introduction Now…
    Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
    In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    728 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

    16 Experts available now in Live!

    Get 1:1 Help Now