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

followup to grc.techtalk

Convert VBA Code to Visual Basic .NET When Migrating to Visual Studio 2005
Tools for Office
http://msdn.microsoft.com/office/default.aspx?pull=/library/en-us/odc_vsto2005_ta/html/OfficeVSTOLanguageMigrationFromVBA.asp

-----------------------------------------------------------
Quote
-----------------------------------------------------------
Dale Oberg
ArtinSoft.com

March 2005

Applies to:
�����Microsoft�Visual�Studio�2005
�����Microsoft�Visual�Studio�2005�Tools�for�the�Microsoft�Office�System
�����Microsoft�Visual�Basic�.NET
�����Microsoft�Visual�Basic�for�Applications
�����Microsoft�Office�2003�Editions
�����Microsoft�Office�Excel�2003
�����Microsoft�Office�Word�2003

Summary: Convert code from Visual Basic for Applications to Visual
Basic .NET when migrating to Microsoft Visual Studio 2005 Tools for the
Microsoft Office System. This document highlights the reasons to migrate,
the major code conversion issues, and additional resources for further
details. (24 printed pages)

����Note���This�article�is�pre-release�documentation�and�is�subject�to
change in future releases. Beta versions of Microsoft Visual Studio 2005
Tools for the Microsoft Office System are included with the Beta versions
of Microsoft Visual Studio 2005.

Microsoft Visual Basic for Applications (VBA) is the environment and
language for Microsoft Office applications that has been available for
several years. Microsoft Office 2003 Editions include a new environment for
building applications called Microsoft Visual Studio Tools for Office
(Visual Studio Tools for Office) which is based on the Microsoft .NET
Framework.

Microsoft Visual Studio Tools for the Microsoft Office System, Version 2003
offered many advantages over VBA, but Microsoft Visual Studio 2005 Tools
for the Microsoft Office System enhances these features for even more user
productivity.

This article reviews detailed coding issues that you must address when
migrating VBA code to Microsoft Visual Basic .NET and Visual Studio 2005
Tools for Office. Future articles in this series focus on migrating
complete projects from VBA to Visual Studio 2005 Tools for Office and also
discuss architecture issues you should consider for VBA projects to take
full advantage of Visual Studio 2005 Tools for Office.

[...]

http://msdn.microsoft.com/office/default.aspx?pull=/library/en-us/odc_vsto2005_ta/html/OfficeVSTOLanguageMigrationFromVBA.asp

-----------------------------------------------------------
Unquote
-----------------------------------------------------------
-- 
Kayode Okeyode
http://del.icio.us/kayodeok
0
kayodeok
3/26/2005 3:18:08 AM
grc.linkfarm 6478 articles. 0 followers. Follow

0 Replies
1231 Views

Similar Articles

[PageSpeed] 2
Get it on Google Play
Get it on Apple App Store

Reply:

Similar Artilces:

can we migrate visual studio .net 2003 project to visual studio.net 2005
Hai friends, I am doing project in ASP.NET(vb language)  I have visual studio .net 2003 installed in my pc and i am doing my project in it , because i need to use additional functionality like "AJAX" , i want to use visual studio .net 2005 or visual studio .net 2008 my project folder name is "sqls" can i install visual studio .net 2005 or visual studio .net 2008 and migrate this project folder to work in visual studio .net 2005 or visual studio .net 2008 i have uninstall visual studio .net 2003 and install visual studio .net 2005 or visual ...

Convert Visual Studio 2008 code to Visual Studio 2005
 I had created my website in  in Visual Studio 2008 in our college, but now I want to run this website at my home,but problem is I have Visual Studio 2005 at my home, so please tell me how can I run this website on Visual Studio 2005.Is there any conversion tool available.Thanks a lot in advance There is no backward conversion tool that I know of. If you are using a web site project (not a web application project), just create a new web site project in VS2005 and point it at a copy of the code.If it is a web application project, you'll have to create a new project and then us...

Why Visual Studio 2005 ask me to convert a solution already got converted Somebody did the conversion of a solution from .net 1.1 to .net 2.0 by using the automatic conversion wizard of Visual Stu
Why Visual Studio 2005 ask me to convert a solution already got converted Somebody did the conversion of a solution from .net 1.1 to .net 2.0 by using the automatic conversion wizard of Visual Studio 2005. Then, he changed to another company. Now, I take over his job. Unfortunately, when I attempted to open that solution, Visual Studio 2005 prompted me the conversion wizard again to forced me to perform a conversion on the solution. Does someone know why?--Harish Patel www.MicrosoftSQLandASP.netpatelharish@gmail.com Hi, How many projects are in the solution, does it have UNLOADE...

Migration of ASP.NET project from Visual Studio.net 2003 to Visual Studio .net 2008
Migration of ASP.NET project from  Visual Studio.net 2003 to Visual Studio .net 2008:      Hi,        I am in the process of migrating the projects developed in Visual Studio .net 2003  to Visual Studio .net 2008. I use the following steps to do the conversion: 1.I create a local copy of the project developed in .net 2003 from source safe. 2.I remove the bindings of the newly created local copy  of the project from sourcesafe. 3.Open VS.net 2008,go to File -Open project/Solution and open the solution file of the proje...

Visual Studio 2005 Express Editions , Visual Basic, Visual C#, Visual J#, Visual C++, and Visual Web Developer Express
Newbie questions....    What is the difference between all this products, i understand now all of them are free of charge, my intention is to build a website, then i do not know if    Visual Basic, Visual C#, Visual J#, Visual C++, and Visual Web Developer Express,  are independent produckts or just some kind of adds to  the last oneI have downloaded visual web developer 2005, and the starter kit, is this all that i need starting to work building my pages or am i missing something else? See the Express Products column in the Visual Studio 2005 Product Lin...

Migrating from Visual Studio .NET 2003 Windows Application to Visual Studio 2005 Web Application
How do I migrate a Visual Studio .NET Windows Application to Visual Studio 2005 Web Application. Are there any tools available for this.  As far as I know there is no direct migration path. You convert VS2003 to VS2005 and then to VS2005 Web Application.Don't forget to click "Mark as Answer" on the post that helped you.This credits that member, earns you a point and marks your thread as Resolved so we will all know you have been helped. manish kumar: How do I migrate a Visual Studio .NET Windows Application to Visual Studio 2005 Web Application. Are there any tool...

Converting Visual studio 2003 to Visual studio 2005 > HttpException was unhandled by user code
Hi,After the conversion of Visual studio 2003 webapplication to Visual studio 2005 ,  whenever the application trying to access session values its getting " HttpException was unhandled by user code .... ; Session state is not available in this context "  error, previously in  visual studo 2003 it was working fine. I think there may be difference in session handling in  Visual Studio2003 and Visual Studio 2005. Hope any one can help me. I am also having the same problem and I would really like to know the solution to this as well....

Visual Studio 2005 Edition Released! Is it the same as Visual Studio.Net 2005 ?
Edited by XIIIVisual Studio 2005 Edition Released! Is it the same as Visual Studio.Net 2005 ? Yes. ".NET" part is not actually/officially part of the Visual Studio 2005 name.-- Mike PopeASP.NET User EducationThis posting is provided "AS IS" with no warranties, and confers no rights. Is it Visual Studio .NET 2003 update version? Does Microsoft change its name? I'm not sure I understand your question exactly -- I'm a little thrown by the word "update." Visual Studio 2005 is the new/current version, released on Monday. This product never officially had the word ".NET" in its nam...

Converting windows application using web service from Visual C#.net 2003 to Visual Studio.net 2005
Hello, everyone! I have a solution which contains a windows project,a web service project and several other library projects. These projects were coded under visual c#.net 2003. Now I need to converted them to use Visual Studo.net 2005. Does any one know any article providing step-by-step guide  to converting WINDOWS APPLICATION with web service? I can find one under MSDN for converting web project.  But I guess I am a little confused if mine should follow this article since I am using web service in my windows application? Thanks a lot in advance.  ...

Visual Basic.NET or Visual Studio.NET?
OK, this has probably been asked before... I'm a student looking to cut my costs, and I can do this by just purchasing Visual Basic.NET as opposed to the fully-fledged Visual Studio.NET application. Of course, I'll only be able to program in VB, but that's fine with me. I wanted to know if all of the ASP.NET specific options are available, such as using a WYSIWYG editor? I'd also like to know if VB.NET has IntelliSense, or that's a specific option only available to Visual Studio.NET users. Thanks in advance. I'd have to believe that VB.Net has intellisense. What is the price d...

Visual Studio .Net? Visual Basic .Net?
Okay, I admit it -- I know nothing about .Net. I'm a Visual Basic and ASP developer. DotNetNuke is my first tentative step into the whole ".Net Thing", and I'm looking for some advice... What do I really need to be able to make some modifications, or new modules for DotNetNuke? Do I need the full, THOUSAND DOLLAR Visual Studio .Net 2003 package, or can I get away with the HUNDRED DOLLAR Visual Basic .Net Standard package?Chameleon Systems, Inc. You can use webmatrix, available here for free. One of the drawbacks of webmatrix however is that it does not support code-be...

migrating ASP.NET code from Web Matrix development tool to Visual Studio .NET 2003
Dear All:Please help me out in giving me ways & means to migrate ASP.NET code from Web Matrix development tool to Visual Studio .NET 2003. I have a project coded from Web Matrix developemt tool in ASP.NET. But I want all those code to be migrated in Visual Studio .NET 2003 developemtn tool, so that I can use the intellesencing & debuging facilities of Visual Studio .NET 2003 at the same developed project.Regards Mullick  mimullick wrote: Dear All:Please help me out in giving me ways & means to migrate ASP.NET code from Web Matrix development tool to Visual ...

Loading Visual Studio.net 2003 on a pc with Visual Studio.net 2005 installed
I have recently installed Visual Studio.net 2005 on a pc and have been using it to create a .net 2.0 application. I also have pc running Visual Studio 2003 that I use to support a .net 1.1 application. This pc has broke. Would I be ok loading Visual Studio 2003 on the machine I have running Visual Studio 2005 so I can manage both the .net 1.1 and the .net 2.0 applications?               Thanks Danny Hmmm. Not sure if it works in that direction, but I installed VS2005 on a machine that has VS2003 already installed and they se...

Creating tables in Visual Studio 2005/2008 through Visual Basic code
 Hello All, I'm developing a website, and I need to automatically generate different sized tables and place web controls in them--such as checkboxes, textboxes, etc. I'm developing using Visual Studio 2005/2008, with my language being visual basic. Basically, I'd like for the page to get some data from SQL database, and based on the info there, to generate a table of x number of rows, y number of columns, and from there, to insert controls a, b, c into cell (1,1), controls d, e, f into cell (2,1), etc. I've been looking for a way to do this, but cant see...

Web resources about - Convert VBA Code to Visual Basic .NET When Migrating to Visual Studio 2005 Tools for Office - grc.linkfarm

Thunderclap Migrating From Twitter to Facebook
Thunderclap, a mass-messaging service that gained popularity on Twitter, has set its sights on Facebook . Twitter recently booted Thunderclap ...

Facebook Migrating Unofficial Page Fans to Official Pages at Brand Owner’s Request
Rupesh Mandal is such an avid fan of the Opera Mini web browser that he set up a Page on Facebook totally devoted to celebrating it, and then ...

Teens Migrating From Facebook To Comments Section Of Slow-Motion Deer Video - YouTube
Subscribe to The Onion on YouTube: http://bit.ly/xzrBUA Trendwatchers say more and more teens are leaving Facebook and Twitter in favor of the ...

UAE is the global leader in attracting migrating professionals, study finds
... with 28 per cent, was the leading source of professionals, according to the LinkedIn study. The UAE is the global leader in attracting migrating ...

Record Numbers of New Zealanders Migrating to Australia
Acting on impulse: why the Kiwis keep coming ... and coming and coming

The krilling season: Whales keep tourists migrating south
Earlybird whale watchers in Eden have been rewarded with astounding acrobatic displays in the bay.

Migrating Swans were bound for glory, says great
Migrating Swans were bound for glory, says great

Researchers say Irukandji jellyfish migrating further south along Qld coast
Researchers say climate change could be altering the migration patterns of the dangerous Irukandji jellyfish along Qld's east coast.

Apple chip supplier TSMC announces record profits, migrating to more advanced technology
... Company , iPhone , and iPad continue reading at 9to5Mac . What do you think? Discuss "Apple chip supplier TSMC announces record profits, migrating ...

More eBay Merchants Migrating to Amazon in Search of Sales Growth
EBay's once-loyal merchants are moving more of their business to Amazon, saying they get more for their money by selling merchandise via the ...

Resources last updated: 12/3/2015 9:47:37 AM