[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 569
  • Last Modified:

Alternative to VBA Excel

Hello,
I have a substantial  program for data collection and archiving.  It is built on Excel VBA and it works quite well.  For a number of reasons I would like to get away from Excel and convert it to another  program that would stand alone.  I would like to have something that is similar to VBA so that I could learn it fairly quickly. I am not an IT pro but I taught myself VBA in the last 6 months and I have no idea what I should be looking at. I have some inkling that C or PHP may be what I need. Would anyone care to suggest what I should be looking at?
Many thanks
David
0
davidam
Asked:
davidam
3 Solutions
 
AndyAinscowCommented:
For a beginner/non programmer I would suggest C# rather than C or C++.  
0
 
davidamAuthor Commented:
Do you think I could replicate all of functionality of VBA(Excel 2003)?
0
 
cupCommented:
There is VB.net - same base engine as C#, similar concepts to VBA.  You could try it out on the express version.  

http://www.microsoft.com/express/Downloads/#2010-Visual-Basic

Note that if you wish to run your program on another machine, you have to copy the executable as well as install .net framework.  Same goes for C#.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
AndyAinscowCommented:
>>Do you think I could replicate all of functionality of VBA(Excel 2003)?

Well, we are talking about a higher level programming language rather than something for providing code for excel worksheets....
All functionality that is NOT specific to excel functions will be available, those specific to excel wont be.
0
 
Carl TawnSystems and Integration DeveloperCommented:
Office Interop will allow you to still talk to Excel if you need to. Plus i'd agree with some of the earlier comments; if you are coming from VBA then VB.Net would be an easier transition that C#. There's a lot of new things to learn in the .Net world, so if you use a language that at least bears some resemblance to one you already know then that will make things easier.
0
 
davidamAuthor Commented:
Good comments...thanks to all.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now