Conversion of VBA to VB.Net

G

Guest

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.
 
S

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.
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB.NET with Excel VBA 3
Problem transferring VBA code w/ ProcOfLine & ProcBodyLine to VB.NET 0
VBA and VB.NET give different results for same RegEx code 5
how to call a vb.net dll from VBA 2
Must VBA be manually converted to VB.NET (C++;C#) to create a DLL or Com Addin? 6
Converting VB.Net to VBA 3
Text to DATE conversion in VBA 1
Dilettante Question: VBA to VB.Net? 5

Top