VBA not installed

system · July 6, 2006, 6:27pm

Hello everyone,

I have a problem here. I just now found out that VBA is not installed when we installed the Business Objects 6.1.3

So now we have the disk to install but we dont have a development environment to test it in before installing it into production. So any one have any idea how to install the VBA using the disc.

Thanks,
pushkar.

pushkar (BOB member since 2006-03-10)

system · July 6, 2006, 6:33pm

Hi,

VBA is installed automatically unless you did administration (command line) installation of BO and you did not specify INSTALLVBA=1 in the command.

So, how did you do your BO installation?

Marek Chladny (BOB member since 2003-11-27)

system · July 6, 2006, 6:36pm

Actually i did not do the installation of Business Objects.A previous consultant did the installation…So i am not sure what he did. And is there any solution or a way to get VBA back…

Thanks in advance,
Pushkar.

pushkar (BOB member since 2006-03-10)

system · July 6, 2006, 6:40pm

I have a basic question:
How do you know that VBA was not installed?

and:
What disk you have and you want to use it for VBA installation?

Marek Chladny (BOB member since 2003-11-27)

system · July 7, 2006, 4:23pm

@pushkar:

Is MSOFFICE installed on your machine.? If you have MSOFFICE then you should have VBA installed for you…

If you want to check whether VBA is installed or not, you can open MS-WORD, Go To -->Tools–>Macro–> Visual Basic Editor.

Copy and Paste the following code, compile and execute it. A message will be displayed for you.

Private Declare Function MsiQueryFeatureState Lib "Msi" Alias "MsiQueryFeatureStateA" (ByVal Product As String, ByVal Feature As String) As Long

Private Sub Command1_Click()
   ' Start Word.
   Dim wdApp As Object
   Set wdApp = CreateObject("Word.Application")
 
   ' Get the Product Code.
   Dim szCode As String
   szCode = wdApp.ProductCode

   ' Get FeatureState for the VBAFiles Feature.
   Dim x As Long
   x = MsiQueryFeatureState(szCode, "VBAFiles")

   If (x = 1) Or (x = 3) Or (x = 4) Then
      MsgBox "VBA is installed"
   Else
      MsgBox "VBA is NOT installed"
   End If

End Sub

Good Luck.

BO_Chief (BOB member since 2004-06-06)

system · July 7, 2006, 4:34pm

Hello,
It gave a message that VBA is not installed. And is there any way to get VBA back.Because I am a report developer and i dont know why VBA is not working and when I ask the admin they says that they have the disk and trying to install it.

Thanks

pushkar (BOB member since 2006-03-10)

system · July 7, 2006, 4:43pm

you have not answered, whether you have MSOFFICE installed ? and Installed correctly ?

As you said you got a message, thats Ok… but by default when you install FC it will also install VBA

There might be another problem… but Its just a guess, VBA might have disabled for you…!!

Now the only way to get it back is, Try installing FC REPORTER with BO CD, After completion, It should install VBA.

After that, run again the VBA code.

Good Luck.

BO_Chief (BOB member since 2004-06-06)

system · July 7, 2006, 4:46pm

Hi,
when do you get this message? What action in BO you need to perform to get it?

The easiest way how to have BO correctly installed would be probably to reinstall it on your computer.

You should also check in Supervisor the command restristions, programmability section of the restrictions.

Marek Chladny (BOB member since 2003-11-27)

system · July 7, 2006, 5:16pm

@pushkar:

Before re-install, first check whether VBA is disabled for you in Supervisor…!! This will save you time, if it works after you enabled it.

BO_Chief (BOB member since 2004-06-06)

system · July 7, 2006, 5:18pm

sure i am just in a meeting with my admin n discussing regarding the same. Thanks a lot for your time and patience.

pushkar (BOB member since 2006-03-10)

system · July 16, 2007, 4:56pm

Chief,

I have a similar issue. I am unable to open the VBA Add-in from the tools menu. I have recently uninstalled BO and then re-installed the FC on my system. I have followed all the above steps like, verified if VBA is installed through MS-Word and enabled the Supervisor restriction to use VBA. The first thing that I noticed was that the VBA was not installed and secondly, I have been enabled to use VBA.

Please let me know the issues and resolutions with regards to resolving this. Thanks in advance.

anupsingh (BOB member since 2006-03-27)

system · July 16, 2007, 5:08pm

VBA should be installed by default… when you install FULL CLIENT software… ?

Check with your BO ADMIN… on this issue.?

BO_Chief (BOB member since 2004-06-06)

system · July 16, 2007, 10:00pm

Thanks Chief,

This problem has been sorted out by uninstalling BO and re-installing it again. I took the help desk’s support in cleaning my registry files to clean up the BO instances. At the same time, any folder pertaining to business objects was deleted manually.

Appreciate your support. Thanks again.

anupsingh (BOB member since 2006-03-27)