Solved

Please suggest any one for my question....

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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Introduction This article series is supposed to shed some light on the use of IDisposable and objects that inherit from it. In essence, a more apt title for this article would be: using (IDisposable) {}. I’m just not sure how many people would ge…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
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…

810 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