Hi, We will just want to describe you of what we are trying to achieve. We are trying to compile a class file to a dll which is compatible on 64 bit Operating Systems and 64 bit Processors. Flip Boom All Star 1.0 Software. Further we are wanting to call a function of this class file in an Excel VBA macro.The dll function returns a value and the macro reads that value and puts it to a specific cell of an Excel File.

I have an application that makes use of various versions of an older COM dll. Some version of the dll use DAO 3. Proteus 7.7 Sp3 Patch. 5 to access a Microsoft Access database and.

We are successfully able to achieve this on machines running 64 bit Operating Systems and 32 bit Office(Office 2003, Office 2007, Office 2010) and 32 bit Operating Systems. We are facing problems only with a combination of 64 bit Operating Systems and 64 bit Office. The steps we followed to compile the dll is as follows: I created a class library in visual studio 2008.The properties set in the Visual Studio Editor is as:- - Application -->Assembly Information-->Make Assembly COM visible Check box Checked. - Compile -->Register for COM interop Check box Checked(Which creates 'Sample.tlb' file) - Signing -->Sign the Assembly.Check Box Checked(Which creates 'Sample.snk' file) - Set the Target CPU as 'Any CPU' and Target Framework as 'Microsoft framework 2.0' Advanced Compiler Setting As we build the solution, following files get created in the Release folder. - Sample.Dll - Sample.tlb - Sample.snk - sample.Pdb - sample.xml Now I place the.dll file and.tlb file in system 32 and syswow64 folder. And then registered the dll as denoted below.- 1. By gacutil /i sample.dll 2.