Check if VBA is installed , if not install VBA from code

Posted on 2011-10-08
Last Modified: 2012-08-13
I need to check if VBA is installed in a clients PC from vb6 , if not install it.. or atleast open VBA installation window from VB6
I kno the VBA installation can e checked through the registry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VBA\Vbe6DllPath... Now I want to install VBA from VB6.
Can this be done?
Question by:winman_soft
    LVL 11

    Accepted Solution

    This is how Microsoft recommends checking if VBA is installed:;en-us;285884

    As for installing from your VB6 app, there will be a folder on the Office disk with the VBA install Setup.exe.  You'd have to make that available somehow to the client systems - and it would have to match the licensed version of Office installed on the system.  You didn't say what version of Ofice you are dealing with, but Office XP and 2003 included VBA in the installation process, however, with Office 2007 and 2010 it is optional.  So you need to deal with the different versions as well.

    Also, if you are automating Office apps, you may have to check the Macros security level setting.  If it is High, nothing will run, Medium, the user will be prompted.

    Author Closing Comment

    thank u

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
    PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

    732 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

    23 Experts available now in Live!

    Get 1:1 Help Now