How to convert VBA code to windows form application in VB.Net

[Manjunath M]

Hi All,

I am new to this, I have written a fully working Visual basic script for excel that uses a User form and an excel template to calculate and create another excel sheet. It is working fine.

Now, I am trying to create a Windows Forms application in VB.NET. I started with manually creating the user form in visual studio item by item. Though it can be done, It is going to take a lot of time. Is there a better way to do this? Can we import the same user form and VB script? Converting the VBA code line by line to VB.NET is taking allot of time.

I have downloaded the Excel-DNA and not able to understand how can I make use of this to transform the VBA code to VB.NET compatible?

Any type of guidance or suggestions and appreciated.

Thank you,

Manjunath B M