Object not available + can't find project or library errors

I am encountering the following two error messages immediately upon running my excel VBA application on a customer's system:
- "Could not load an object because it is not available on this machine", followed by
- "Compile error: Can't find project or library"

The application runs just fine on all other systems that I have run it on (Excel 2010 and 2013). The only obvious difference between my customer's system and others is that they are using the 64 bit version of Excel. When I first tried to run it on their system, I received error messages related to API function declarations but I have since fixed that (I think!) by providing both 32 bit and 64 bit versions using the code suggested here: http://www.jkp-ads.com/Articles/apideclarations.asp and a conditional compile using #If VBA 7 then ... #Else ... #End If. This eliminated the declare errors but then these other two errors popped up. In case it is relevant, the API functions I am using are: getFrequency, getTickCount, SendMessage, GetDeviceCaps, GetDC, and ReleaseDC.

I have tried what I understand to be the usual ways to solve this but with no luck, e.g.:
- viewing references in the VBA editor on their system shows all the expected references are checked off and none are flagged as MISSING
- I had the customer turn off a couple of COM add-ins that they had active, but no change
- I had the customer confirm that all windows updates have been installed
- I sent them a basic .xlsm file that just copied a value from one worksheet cell to another when a button was pushed, and that worked fine on their end

At this point I'm not sure what to try next. Any suggestions for other things to try out? Is there any way to find out what specific objects, projects or libraries are causing the problem? Any thoughts would be appreciated, and let me know if I should provide more details. Thanks.

Hi iswehr an welcome to Excel Forum,

My speculation is that you are using a Date Picker control that requires Active X library MSCOMCT2.OCX. To the best of my knowledge that library is NOT AVAILABLE for use with 64 bit Excel. There are numerous alternatives available that don't require the library. For additional information see:
http://www.logicwurks.com/CodeExampl...erControl.html
http://excelribbon.tips.net/T002080_...te_Picker.html

Lewis

Hi Lewis - thanks for the suggestion, and for the welcome! We don't actually use a date picker active X control anywhere in our application (we've tried to avoid Active X controls in favour of form controls). Feels like you might be on the right track though ... do you know if there are other controls, etc. where a similar 64 bit conflict might exist? For instance, we use the SendMessage, GetDeviceCaps, GetDC, and ReleaseDC API functions I mentioned in the original post to create an interactive branching tree structure view in some of our userforms that requires MSCOMCTL.OCX My customer's system doesn't flag that library as missing, but perhaps there are still differences causing a conflict?

-Stephan

Thanks for the additional ideas and looking into those items - appreciate the effort. I'll take a look at these and cross-check my declarations with the ones you have posted. Thanks again.

-Stephan

Ahh - I guess that's the culprit then. I see now that this incompatibility is confirmed at https://msdn.microsoft.com/en-us/lib...nCompatibility

Looks like there are some non-active x alternatives to Treeview available (e.g. http://www.jkp-ads.com/articles/treeview.asp ). Will have to look into that. Thanks to you both for helping to track down this issue.

- Stephan