Please suggest any one for my question....

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..
mannevenu26Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jacques Bourgeois (James Burger)PresidentCommented:
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
Bob LearnedCommented:
Agreed...rewrite...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Miguel OzSoftware EngineerCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
C#

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.