Channel 9

Entries:
Comments:
Posts:

Loading User Information from Channel 9

Something went wrong getting user information from Channel 9

MSDN

Activity Profile

Latest Achievement:

Loading User Information from MSDN

Something went wrong getting user information from MSDN

Visual Studio Achievements
Visual Studio Achievements

Latest Achievement:

Loading Visual Studio Achievements

Something went wrong getting the Visual Studio Achievements

VBA interop with VSTO managed code in VS 2008

Embed code for this video

Copy the code above to embed our video on your website/blog.

Close

Video format

Option selected may change based on video formats available and browser capability.

Close

Download

How do I download the videos?

  • To download, right click the file type you would like and pick “Save target as…” or “Save link as…”

Why should I download videos from Channel9?

  • It's an easy way to save the videos you like locally.
  • You can save the videos in order to watch them offline.
  • If all you want is to hear the audio, you can download the MP3!

Which version should I choose?

  • If you want to view the video on your PC, Xbox or Media Center, download the High Quality WMV file (this is the highest quality version we have available).
  • If you'd like a lower bitrate version, to reduce the download time or cost, then choose the Medium Quality WMV file.
  • If you have a Zune, WP7, iPhone, iPad, or iPod device, choose the low or medium MP4 file.
  • If you just want to hear the audio of the video, choose the MP3 file.

Right click “Save as…”

Author: Hi, I am Daniel Moth Smiley

Introduction: With VSTO v3.0 the attraction to write managed code in order to customise Office applications is huge. However, if you already have investments in VBA code, you do not need to throw it out just yet. Just interop, like I show in this 8' video. For other resources, start at my blog post here.

Video download: Click on the image to play the video (from a streaming file). If you'd prefer to download the wmv packaged in a zip file, you may do so here.

Tags:

Follow the Discussion

  • cotassoncotasson
    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 !
  • cotassoncotasson
    Hello again,

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

    Cheers.
  • Daniel MothDaniel Moth
    Hi cotasson

    Glad you found a solution soon after posting the question. For future VSTO questions the best place is this forum:
    http://forums.microsoft.com/msdn/showforum.aspx?forumid=16&siteid=1

    Cheers
    Daniel

Remove this comment

Remove this thread

close

Comments Closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.

More posts in this blog

See More

Related posts

Creative Commons License

© 2013 Microsoft. Except where designated as licensed by
Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 License,
Microsoft reserves all rights associated with the materials on this site.