Groups | Blog | Home
all groups > vb.net upgrade > march 2004 >

vb.net upgrade : vba to vb.net


Mattias
3/8/2004 8:20:06 AM
Hi

Does the conversion tool vb6 to vb.net accept vba code as well or do I have
to convert from vba to vb6 first..

I only have Office Developer XP...not vb6 or visual studio.

Appreciate some advice on this.

Mattias

hirf-spam-me-here NO[at]SPAM gmx.at
3/8/2004 6:27:12 PM
* "Mattias" <infombase@home.sol.se> scripsit:
[quoted text, click to view]

AFAIK only VB6 projects are supported.

--
Herfried K. Wagner [MVP]
Mattias
3/8/2004 7:10:05 PM
Hi

As one cannot buy vb6 any more...do you know any place where I can download
a trial free somewhere?

Mattias
[quoted text, click to view]

hirf-spam-me-here NO[at]SPAM gmx.at
3/8/2004 7:22:40 PM
* "Mattias" <infombase@home.sol.se> scripsit:
[quoted text, click to view]

AFAIK such a version of VB6 doesn't exist for download. Some books may
include the working model edition, but this version is very limited in
functionality.

--
Herfried K. Wagner [MVP]
Howard Kaikow
3/10/2004 12:39:18 AM
If you check at www.pricegrabber.com there are still a few places selling VB
6 and visual studio 6,
One of those is www.atomicpark.com. Don't know anything about them, but I've
heard of them.

--
http://www.standards.com/; See Howard Kaikow's web site.
[quoted text, click to view]

robdil NO[at]SPAM msonline.microsoft.com (
3/10/2004 5:12:11 PM
While the other replies are correct in that there is no conversion tool
from VBA 6.0 to managed code (VB.NET), you may be able to utilize your
existing code with the the new Developer Edition for Office 2003. There is
some good reading on
http://msdn.microsoft.com/office/understanding/vsto/articles/default.aspx?pu
ll=/library/en-us/dno2k3ta/html/odc_ofcomparevba6andvsto.asp. It really
depends on the functionality of the code that you want to move to VB.NET.

--------------------
[quoted text, click to view]

Regards,
Rob Dil [MSFT]

This posting is provided "AS IS", with no warranties, and confers no rights.
Mattias
3/12/2004 11:46:23 AM
Hi and thanks...It seems to be interesting..Do you know when it is available
to buy..?

Mattias
[quoted text, click to view]

Howard Kaikow
3/13/2004 1:04:03 AM
THere is, AFAIK, nor developer edition of OFFice 2003.

There is a Visual Studio Tools for Office, but it does not really truly
integrate with Office.
You'd do just as well, perhaps better, using VB 6 to automat Office,
especially since compiled code in VB 6 is protected from prying eyes, .NET
code is not at all protected.

Also, if you buy VB 6 first, then you are likely eligible for an upgrade
price for VS .NET.
Check the requirements at MSFT's web site.

--
http://www.standards.com/; See Howard Kaikow's web site.
[quoted text, click to view]

robdil NO[at]SPAM msonline.microsoft.com (
3/18/2004 10:34:38 PM
The replacement product for the Microsoft Office Developer Edition is the
Visual Studio Tools for Office. From the Microsoft site:

Microsoft Visual Studio Tools for the Microsoft Office System
This is a new suite of software tools that allows developers to combine the
productivity and power of Visual Studio .NET and the .NET Framework with
the extensibility and programmability of Office 2003. With this technology,
developers using Visual Studio .NET 2003 can use Microsoft Visual Basic
.NET and Microsoft Visual C# .NET to write code behind Word- and
Excel-based applications.

Microsoft Office Access 2003 Developer Extensions
The Access 2003 Developer Extensions provide the tools and resources
developers need to more quickly and easily create, test and deploy
sophisticated Access solutions. The Developer Extensions include a
royalty-free Access Runtime enabling distribution of Access solutions. The
Developer Extensions also include tools, with source code, for creating
professional setup routines, globally searching solutions for custom
strings and creating solutions that have been stripped of all source code.
The Access 2003 Developer Extensions are part of the Microsoft Visual
Studio Tools for the Microsoft Office System. You can find more information
on http://msdn.microsoft.com/office/.

The 2003 version of Visual Studio .NET includes a third party addin from
PreEmptive Software to obfuscate your code. Check out the PreEmptive site
at http://www.preemptive.com


--------------------
[quoted text, click to view]
<c2ibja$1te039$6@ID-208219.news.uni-berlin.de>
<OLssUiTBEHA.3776@tk2msftngp13.phx.gbl>
<KutMgLsBEHA.2304@cpmsftngxa06.phx.gbl>
<#4WNE9BCEHA.2824@TK2MSFTNGP12.phx.gbl>
[quoted text, click to view]
cpmsftngxa06.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08
.phx.gbl!tk2msftngp13.phx.gbl
[quoted text, click to view]

Regards,
Rob Dil [MSFT]

This posting is provided "AS IS", with no warranties, and confers no rights.
Howard Kaikow
3/19/2004 8:33:06 PM
VSTO is not integrated with Office 2003.
It just makes it easier to use .NET with Office 2003.

However, those solutions do not port to lower versions of Office such as
Office 97 and Office 2000, and the code is NOT secure from prying eyes.

Using VB 6, you can write code that can be used with Office 97 and up, and
the code is secure from prying eyes.

--
http://www.standards.com/; See Howard Kaikow's web site.
[quoted text, click to view]

AddThis Social Bookmark Button