Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Upgrading to Basic.net. Is VBA dead (or dying)?
Folks,
I need some advice from the MVP's out there. I have a lot of Excel/VBA applications that I have developed over the last 5 years. These applications are for financial forecasting, consolidating financial statements, sales and cost analysis, and derivative pricing models. Many of these apps are really complicated (hundreds or even thousands of lines of code) and most are still in use. I presume that these apps will all have to be eventually converted to Basic.net? And, since any major upgrade is going to come with a client "wish list", that could be a lot of work. So, do I start building new libraries and push the clients to convert now? Is Version 12 is going to support VBA? If so, this may give me another 18 months of breathing room. What about new Excel projects? I would think that I should use .net for all future projects. Assuming my code is fairly structured and well commented, how difficult is it going to be to convert to ..net. Any experience you experienced programmers could give me here will be helpful. Cheers, Allan P. London, CPA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Upgrading to Basic.net. Is VBA dead (or dying)?
Read this from a program manager for the MS Office team:
http://blogs.msdn.com/brian_jones/ar...12/438262.aspx Quote: "We are by no means moving away from VBA though, which is why we have the macro-enabled versions of the new formats. VBA is still very important for a ton of our customers, and we will continue to support their solutions going forward using the new file formats. " If Microsoft dropped support for VBA, that might just be the catalyst that pushed a lot of customers away from MS Office and toward Open Office. They can't risk that. So I wouldn't put any time or effort into converting exisiting code to ..NET, but it probably isn't a bad move for future work. My $0.02, Nick Hebb BreezeTree Software http://www.breezetree.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Brain Dead | Excel Discussion (Misc queries) | |||
Brain Dead: Need help with ???? | Excel Worksheet Functions | |||
Is ADO dead? | Excel Programming | |||
Handling Dead Hyperlinks | Excel Programming |