Comments by nigam.anant (Top 7 by date)

thanks for your feed back.I read the Link "http://support.microsoft.com/kb/828550" and apply the Changes as per suggested in the Link.then when i Executed the Code when the function of DLL calls it give error 429 "Active X component did not Create Object"...
here i depicted the VBA code which i use.
---------------------------------------------------------------------
Sub CallMult3()
On Error GoTo Err
Dim Count As Integer
Count = Cells(35, 16)
Dim abc As New SampleTEST.Cls_SampleTest

'Dim abc As SampleTest.Cls_SampleTest
'Set abc = CreateObject("SampleTest.Cls_SampleTest") '//* if this line is not commented then it give Error 429

FlagForAuto = 1

CounterForInitialEntry3Call = 0

Range("X16:AA35").Select
Selection.ClearContents

Cells(1,1) = abc.Main(ThisWorkbook.FullName, Cells(440, 5), Cells(12, 11)) '//*when this line Executed it gives error 429

FlagForAuto = 0

Exit Sub

Err:
MsgBox Err
Cells(10, 1) = 4
Cells(11, 15) = 99
End Sub
-------------------------------------------------------------------
I also include the libraries..
1. Sample.tlb
2. Microsoft Active X 6.0 Object Library
3. 'Microsoft Office 14.0 Access Database Engine Object'

I run this code in MS Office 2010 64 bit and 64 bit Operating System.
So, please kindly help us address this issue. Awaiting help eagerly.

Thank you,
regards,
Vaibhav.

Hi Williams,

Thank you very much for the feed back. We tried including the ACEDAO.dll from the mentioned path but that also did not seem to work and it still shows up the same error code "429". Just to add that we are using simply Microsoft Excel making an attempt to call a dll function which in turn is compiled using Visual Studio 2008 with Debug Configuration set as "Any CPU". We are not trying to access any Database.

Simply we are trying to call a dll function within an Excel Macro.This works absolutely fine on all machines with 64 bit OS and 32 bit Office Excel. The error/problem comes up only on machines with 64 bit Office.

So, please kindly help us address this issue. Awaiting help eagerly.

Thank You,

Regards,

Vaibhav Pandya

Hi,

Thank You very much for the feed back. When we try to include the ACEDAO.DLL from the path that you mentioned in the Tools--> References in the Macro, the dll is not populated in the List of dlls. So we browse and then eventually add the same dll but that also did not solve any purpose and still the error code remains the same which says "429".

Let me summarize everything related to the problem. We are trying to achieve call a function from a dll compiled using Visual Studio 2005 with Build Configuration set as "Any CPU" in an Excel Macro. The dlls/References that we are including in the macro are as :

Microsoft Active X 2.1 Object Library
Microsoft DAO 3.6 Object Library
Tlb File of the dll that we compile.

Everything works fine on machines where there is 64 bit Operating System and 32 bit Office(Excel). The problem only occurs when we are trying to call the Macro which in turn calls the dll function on machines with 64 bit OS and 64 bit Office(Excel).



Please, kindly suggest us a resolution on this problem to the earliest.


Thank You,

Regards,

Vaibhav Pandya