Skip to Content
author's profile photo
Former Member

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

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 ."

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo
    Former Member
    Posted on Oct 19, 2010 at 10:36 AM

    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?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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.