John R. Durant's WebLog

Blog of "The" Office Developer

Migrating VBA code to Visual Studio Tools for Office

I am starting to realize that I need to post more than once a day. There's just so much going on. I'll kick it off today by saying that we just published a new and rather important article on the site:

Convert VBA Code to Visual Basic .NET When Migrating to Visual Studio 2005 Tools for Office

This article is not the complete story on migration (easy does it my friends!). It is designed to address issues like: Can I used default properties in a Visual Studio Tools for the Microsoft Office System solution? Or: If I am accustomed to declaring fixed length strings in VBA a certain way, can I do that in VSTO? And: What's the story on late-binding in VSTO?

A lot of these issues in the paper have little do with VSTO per se and more to do with migrating to the .NET Framework. Intringuingly, this paper comes at a time when our discussion of VBA/VSTO (evolving from our task pane discussion) is still going on here.

 Rock Thought for the Day: I mentioned the Sex Pistols yesterday. Well, I just heard about this band, Beatsteaks. They opened for the Pistols back in the mid-90's and are on tour right now. Good punk band with a stronger melodic focus than one normally expects.

Rock On

Published Wednesday, March 23, 2005 8:33 AM by johnrdurant

Comments

 

Stephane R said:


VSTA?
March 23, 2005 9:38 AM
 

lee chan jong said:

help
March 24, 2005 12:48 AM
 

Tobek said:

I've been blogging my findings on my part-time project to move a Word add-in over to VSTO: http://spaces.msn.com/members/tobek/PersonalSpace.aspx?_c=.

I keep gettin distracted by other things, so it's been a few weeks since I've done any work on it...

And BTW, I'm another Office programmer who cycles (road) - competitively till my knee crapped out several years back.
March 24, 2005 12:46 AM
 

Donn Edwards said:

Why do we have to learn all this .NET stuff? Is VBA going to be phased out completely in the next version of Office?

I wonder if the next version of Office will be written in a .NET language? I think not.
March 24, 2005 2:26 PM
 

Stephane R said:


>> I wonder if the next version of Office will be written in a .NET language?

My humble opinion? No, it won't be rewritten. Offically answer heard on this many times already : the current Office app is tested, so why rewrite it.

VSTO is kind of leading the Office of the future, meaning adding features in the OLE streams with components entirely written in .NET.

But then, the big question is how are customers going to react to this? IMHO only a fraction of these are ok to switch to Visual Studio in order to automate stuff, and everybody else wants to stick in Office itself (VBA, or whatever compatible with it) to get their job done.

Sounds like yet another migration equation to solve...

March 25, 2005 2:38 PM
Anonymous comments are disabled

© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Microsoft
Page view tracker