Conversion of VBA to VB.Net

[K.R.Karthick]

I have Excel application in a VBA format.I like to convert the same coding in
to VB.Net ,for taking advantage of managed codes.

I like to know ,whether any tool is available for converting VBA to VB.Net.

Your help is appreciated.

 

[Stephen Bullen]

Hi K.R.Karthick,

I have Excel application in a VBA format.I like to convert the same coding in
to VB.Net ,for taking advantage of managed codes.

I like to know ,whether any tool is available for converting VBA to VB.Net.

No, there isn't. My advice would be to leave your VBA code as it is. To take
advantage of managed code, expose your managed code procedures as COM Classes,
which can be referenced and called from VBA.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk