[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 801
  • Last Modified:

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

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?
1 Solution
This is how Microsoft recommends checking if VBA is installed: http://support.microsoft.com/default.aspx?scid=kb;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.
winman_softAuthor Commented:
thank u

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now