4 ms·
As a practical matter, if I read the article correctly, VBA is only going away for the Mac. Is that the platform you're working on? If not, no problem. If so
by mxh 19y ago
As a practical matter, if I read the article correctly, VBA is only going away for the Mac. Is that the platform you're working on? If not, no problem. If so:
1.) Not upgrading sounds good .... it's cheap!
2.) You could move to a PC.
3.) You could learn the beauties of CSV format, and the language of your choice. I like Python, but something else might be better for your domain.
The Larger Issue here, IMO, is the peril of using proprietary technologies. It seems unwise to build any long-term project in something a vendor can too easily end-of-life.
- omouse 19y agoI just stumbled upon this: http://www.oreilly.com/catalog/pythonwin32/chapter/ch12.html http://www.oreilly.com/catalog/pythonwin32/chapter/ch12.html And this: http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/440661 http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/440661 Don't you just love Python?
- sethjohn 19y agoYes, I work on a Mac. The nice thing about VBA was that you could mostly work in Excel, only using VBA to supplement when neccessary. (Open another file to import data, for example. Or take a value from cell X, and plug it into cell Y a couple hundred times until the answers converged.) You are right about the Larger Issue, perhaps this is a blessing in disguise as an opportunity to wage my own personal war against the Microsoft Monopoly.