On Jun 18, 4:30 pm, cpet_mag...@hot mail.com (Camille Petersen) wrote:
I have a rather old VisualBasic program which is included inside an Access *.mdb database.
So I guess it is an VisualBasic and not and VBA program.
Can I somehow automatically convert it into a VisualBasic program outside of Access
which is working on base of .NET ?
If yes: How do I do it ?
If no: Is there way of at least let me automatically convert it with a
minimum of additional manual changes/interventions?
Camille
Hi Camille,
VB inside MS Access is VBA (Visual Basic for Applications). Whether
you can 'translate' it or not will depend entirely upon how much the
code relies upon 'Access' features. I have just spent a couple of
months re-writing an Access front end into VB.Net and it is not a
simple task.
If you extract the VBA code into a .bas (or .cls) module and join
those together as a .vbp (Visual Basic 6) project, you may be able to
use the conversion by opening the .vbp file .NET, other wise you can
try doing small parts at a time using the in-line converter.
Because VBA code, whether in Access or Excel, relies fairly heavily on
built in functions of the host program, I would not expect to get
anything like a clean conversion. Depending on the size of the
project, you may be better advised to re-write from scratch.
David