Excel 64bit: ActiveX component can't create object

[dervander]

I've been using a COM dll in all previous versions of XL but now that I'm running Office 2010 64bit I get the error "ActiveX component can't create object" when I try to instantiate the object from the linked library

<code>
Set mCrypKeyObj = New CrypKeySDK7
</code>

The library comes from a third party (Crypkey) and they claim it's 64 bit compatible. I'm skeptical but maybe there's something else I'm doing wrong.

Has anyone run into this before?

Is there an easy way to tell if a 3rd party dll is truly 64 bit compatible?

Thanks for any time you can spend contemplating this.

Derrick

 

[Derek Brown]

Microsoft recommends Office 32-bit on Windows 7 64-bit.
There is a link to the Microsoft page in my post #9 at:
http://www.mrexcel.com/forum/showthread.php?t=447852
Also see Rory's post #11 on page 2.
You may find something here: http://www.microsoft.com/windows/compatibility/windows-7/en-us/default.aspx

 

[dervander]

Thanks Derek,

Yes and I guess I can be glad that they recommend 32bit for now as it makes it more likely our customers will be using it.

However I maintain a piece of software that runs in Excel and we use Crypkey to protect it. I'm just trying to iron out the bugs involved with running our software in Excel 64bit so we'll have a product that's working and tested when our customers start to use the 64bit version of office. One way or another that means getting this dll to work in 64bit. The first steps seem to me to be to to make sure I'm not doing something wrong at my end and to ensure that this dll is genuinely written for 64bit(I'm guessing using some kind of software to check it).

 

[Derek Brown]

In case it is useful in the future (I could not find any reference to Crypkey in it), here is a list of applications with compatibility status:

http://www.microsoft.com/download/en/details.aspx?id=2394