Solved

Please suggest any one for my question....

Posted on 2014-09-25
4
98 Views
Last Modified: 2014-10-06
Hi

I am having one requiement for converting the code from vba macro excel to c#.net.....

In the excel vab macro is having some modules ans class modules these pages need to be convert into c# code.

Could you please suggest like any converter are available or online tools are available or download from any site....

Please let me know ASAP.....:)

Thank you inadvance..
0
Comment
Question by:mannevenu26
4 Comments
 
LVL 40
ID: 40345286
I don't even know of a good converter between VBA and VB.NET. There are too many things to consider for a converter to do a good job. Even the converter between VB6 and VB.NET is a mess, although there are more similitudes between VB6 and VB.NET than there are between VBA and VB.NET.

 So asking to completely change the language to C#... Good luck.

The only good converter is the programmer who has experience of both, and know about the potential problems of working with Excel from .NET.

Sorry, that is not the answer you expected, but this is the best one... in my humble opinion.
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 40345987
Agreed...rewrite...
0
 
LVL 25

Accepted Solution

by:
apeter earned 500 total points
ID: 40346827
0
 
LVL 35

Expert Comment

by:Miguel Oz
ID: 40347279
I do agree with James and Bob. I did some work like that in the past and it was a challenge as some of the VBA constructs are different and the VBA code was copy/paste/spaghetti all over the place- not to mention the VBA code state. You are better off either your team doing it and contracting someone else to do it for you.
The VBA code tends to be messy especially if power users wrote it. Even it is possible to use a converter, are you sure you want to maintain that generated C# code?
Rewrite will require grab the original requirements or build some requirements as well as having the VBA code to verify that this works as advertised or in case you find some magic constants floating around.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In order to hide the "ugly" records selectors (triangles) in the rowheaders, here are some suggestions. Microsoft doesn't have a direct method/property to do it. You can only hide the rowheader column. First solution, the easy way The first sol…
Article by: Najam
Having new technologies does not mean they will completely replace old components.  Recently I had to create WCF that will be called by VB6 component.  Here I will describe what steps one should follow while doing so, please feel free to post any qu…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now