cancel
Showing results for 
Search instead for 
Did you mean: 

Run-time error '429':Active X component can not create an object

Former Member
0 Kudos

Hi Folks,

I am using some VBA code to run logic in BPC for Excel. When i try to click on VBA button, It's giving the below error.However when i am trying to execute same from server it is working fine. Accessing from BPC client only we are facing this problem.

Code have no issues. Is there any specific thing need to mentioned in client when we use VBA programming? Basically we used the VBA program to create the id's in BPC for Excel. So that it will automatically created on fly. Testing was fine interms of working in Server.

" Run-time error '429':Active X component can not create an object ."

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Are you trying to add a member into the dimension from excel? As you said that this has been already tested in the server and is working fine, I believe, you have taken care of everything.

Now, coming to the point, when you are adding a member in the membersheet, you need to process the dimension. This requires the admin rights. So, please check the task profile of the user ID, with which you are trying from your system. This user ID should be the primary admin.

Hope this helps.

Additionally, can you please elaborate on the steps on what you followed for adding a member from the excel directly?

Former Member
0 Kudos

Hi All,

I am getting this same error just by opening BPC for Excel Interface and changing the Current View for any dimension. I've tried reinstalling Microsoft Office and the BPC Netweaver suite. Have you ever faced this error in this situation? I've also tried other computers from my peers but no errors appear.

Any help will be greatly appreciated.

Kind regards,

David

Former Member
0 Kudos

Hi,

I am getting the very same error after opening BPC for Excel Interface and changing the Current View for any dimension.

I tried unstall & installing the BPC Netweaver. We are using BPC 7.5 (vr Netweaver) & MS Office 2010 in Windows 7 OS. Other computers operate successfully without any issues.

Please advice.

Thanks & regards,

Manoj

Former Member
0 Kudos

. Make sure into IIS that your Osoft virtual directiry is using ASP.NET 2.0

2. Did you install AntiCross scriptuing library from Microsoft? (AntiXssLibraryV1.5Installer.msi)

If you installed after installation of BPC then you have to copy the AntiXss.dll from installation folder for ASP.NET 2 into C:\BPC\Websrvr\Web\bin

3. Make sure NT AUTHORITY\NETWORK SERVICE has the correct rights into windows\Temp folder.

Before performing the above steps. try to restart your pc and check. Thanks

Former Member
0 Kudos

Try this first

- Open a command session: Do start->run and type cmd

- In the command prompt, enter DEL /S /A:H /A:-H *.EXD and restart the machine.

- This command recursively deletes all the hidden and exposed exds.