Entries:
Comments:
Posts:

Loading User Information from Channel 9

Something went wrong getting user information from Channel 9

Latest Achievement:

Loading User Information from MSDN

Something went wrong getting user information from MSDN

Visual Studio Achievements

Latest Achievement:

Loading Visual Studio Achievements

Something went wrong getting the Visual Studio Achievements

cotasson

cotasson cotasson

Niner since 2008

  • VBA interop with VSTO managed code in VS 2008

    Hello again,

    I found this article:
    As a matter of fact, I was coding in C#, this might be the reason why.

    Cheers.
  • VBA interop with VSTO managed code in VS 2008

    Hello Dan,

    I am currently working on VSTO.
    As far as I know, it is not possible to write Excel UDFs directly in .Net, you have to rely somehow on VBA as a gateway to do this.

    Your screencast does just what I need to implement.

    I try to implement the second part of the screencast, to no avail.

    The properties pane for the "workbook", under the VBA Interop category does not show the "VBACallsEnabled" option. However the second one,
    "ReferenceAssemblyFromVBAproject" is featured.

    I set it to "true", run the project, but the DLLs are not referenced, nor the VBA code referencing the .Net created...

    Any ideas, tips, would help.

    I have VS Studio 2008 Pro Edition, running on XP Pro.

    Thanks.

    PS : All that aside, I found your videos on VSTO quite instructive, far more than other VSTO videos I found elsewhere....
    Congrats !