Solved

Please suggest any one for my question....

Posted on 2014-09-25
4
112 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
This article introduced a TextBox that supports transparent background.   Introduction TextBox is the most widely used control component in GUI design. Most GUI controls do not support transparent background and more or less do not have the…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

820 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