Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a series of big excel files that work like a program, but I hate beeing tied up (stuck in VBA for excel 2003), so...

Whats the best way to implement a gui over a excel vba program (office 2003)? (are there any tools for that... I want to move away from the office suite, but still have it in the background)

Or what's the easiest alternative for migrating this code to a more open language. Any ideias?

share|improve this question
1  
Wow, tough ask. It depends what you're doing. For instance, you could migrate the VBA code to a Visual Basic.NET platform, and then do the UI inside VB as well ... lots of possibilities. –  user3463 Mar 8 '10 at 12:53
1  
Are you also trying to avoid the requirement of an Excel license for each user? –  PaulWaldman Mar 8 '10 at 16:05
    
Without trying to move this to a discussion, I really would like to move away from M$, due to licensing costs –  Krazy_Kaos Mar 8 '10 at 16:14
    
@Randolph Potter: Have you got any experience in migrating VBA to VB... is it much pain?? –  Krazy_Kaos Mar 26 '10 at 11:42
    
I've moved from VBA to .NET and it's a pain. Usually it makes more sense to re-design the application for the new platform, than port it directly. –  user3463 Mar 31 '10 at 6:07

2 Answers 2

You can design userforms to act as the UI then use application.hide to hide the Excel interface, so the user never sees Excel. I've done it on a few projects in the past with no problems.

share|improve this answer

Since you mention licensing as a reason. LibreOffice might work for you. Probably nothing will just work without some conversion on your part. Depending upon what is being done, you can do a surprising amount in a simple web application, with any number of languages available for free.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.