Databases
StackOverflow2013
Postsdbo
POUnable to instantiate COM library built with Visual Studio 2008 in VBA inside a 64 bit application
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUnable to instantiate COM library built with Visual Studio 2008 in VBA inside a 64 bit application
    primarykey
    data
    text
    <p>I am trying to build an object library which can be registered and used from VBA using 64 bit excel 2010. I am using Dev Studio 2008. I think this is a 64 bit issue as I am pretty sure this worked when I tried it with with my previous version of Excel (XP). I have clicked "Make COM visible" in the Assembly info Information dialog and "Register for COM interop" in the build tag. When I set the target type to x64 I can't see the library in the references dialog at all. I if I select Any CPU I can register it but I get a "Can't create Active X object" error when I try to instantiate it.</p> <pre><code>namespace Tester { [Guid("D6F88E95-8A27-4ae6-B6DE-0542A0FC7039")] [InterfaceType(ComInterfaceType.InterfaceIsDual)] public interface _Numbers { int GetDay(); int GetMonth(); int GetYear(); int DayOfYear(); } [Guid("13FE32AD-4BF8-495f-AB4D-6C61BD463EA4")] [ClassInterface(ClassInterfaceType.None)] [ProgId("Tester.Numbers")] public class Numbers : _Numbers { public Numbers(){} public int GetDay() { return(DateTime.Today.Day); } public int GetMonth() { return(DateTime.Today.Month); } public int GetYear() { return(DateTime.Today.Year); } public int DayOfYear() { return(DateTime.Now.DayOfYear); } } } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCyril Gupta
    1. USShane
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POUnable to instantiate COM library built with Visual Studio 2008 in VBA inside a 64 bit application
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCan you try manually running the 64-bit version of `regasm.exe` on your assembly and see if it fixes the problem?
      singulars
      1. POUnable to instantiate COM library built with Visual Studio 2008 in VBA inside a 64 bit application
      1. USFrédéric Hamidi
    2. COUsing the 64 bit version of regasm should be the solution as mentioned here: http://support.microsoft.com/kb/982280 but it doesn't mention that if you want reference it from VBA you need the export a type library by /tlb:<path to type lib>. However when I do this on on 64 bit build uisng the 64 bit version of regasm, I now the error "Automation Error: the system cannot find the file specified"
      singulars
      1. POUnable to instantiate COM library built with Visual Studio 2008 in VBA inside a 64 bit application
      1. USShane
    3. COJust got it working - you also need to add the /codebase flag, so the full command line is regasm /codebase /tlb:<path to type lib export> <path to assembly to register>. If you want to put all the relevant info in an answer I will accpet it, it might help someone else.
      singulars
      1. POUnable to instantiate COM library built with Visual Studio 2008 in VBA inside a 64 bit application
      1. USShane
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload