Reply to thread

Message: <blockquote data-quote="seanna2000" data-source="post: 4632505" data-attributes="member: 81371">Actually, Microsoft didn't change VBA to anything else in Office 2007. They just added further support for certain MS Office applications to VSTO (Visual Studio Tools for Office) which started in Office 2003 if I'm not mistaken. VBA is still a built-in part of Office, whereas VSTO is a kind of add-on to Visual Studio, which requires really expensive licensing. So unless Wonko is a rich fella (i.e. already has or can afford to buy Visual Studio .NET), or a REALLY BIG fan of Microsoft, he's stuck with VBA. Which is why I chose to discuss more on things that are easier to obtain. VBA isn't bad if you know how to use it, though I admit it is rather pale compared to full-blown Visual Basic .NET and Visual C# .NET, or even the classic Visual Basic 6. As for using XML versus using CSV files, I personally think that it would be a lot easier and better to use CSV files or something similar, as they are simple and orderly (from a programming point of view). You would need to worry so much less about what you could and couldn't do with the XML. Plus XML is only important if you want to do special formatting. No point using a cannon to kill a mosquitoe. CSV would be simple and easy, as you would only need to export and import in order, which requires much less research on Wonko's part. What is better or worse depends on the problem at hand, no? You could say C is far better than Prolog, but Prolog can do rule-based AI with much less effort and code. So I would personally suggest that Wonko not make things more high tech than necessary. Simplicity is best. He is after all, only going to export and import values from his spreadsheet. As for Excel, true, you can do a lot with Excel, but I was just mentioning that it would have been so much simpler with Access and VBA had that been the platform that was used from the beginning. However, at this point, it would take a lot of effort to shift to a different platform, although it is still possible to use VBA in Excel as well. It's just that a database would have made life a lot easier, that's all.</blockquote>

Verification