Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Please suggest any one for my question....

Posted on 2014-09-25
4
Medium Priority
?
121 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 1500 total points
ID: 40346827
0
 
LVL 36

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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Article by: Ivo
C# And Nullable Types Since 2.0 C# has Nullable(T) Generic Structure. The idea behind is to allow value type objects to have null values just like reference types have. This concerns scenarios where not all data sources have values (like a databa…
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…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

670 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