The trouble is that when people develop VBA scripts for Excel, it's unlikely they consider whether their script is going to be used with a different application.īut all is not lost. VBA compatibility in, for example, should be considered a work in progress. This means that if your spreadsheet relies on VBA functionality to work, you may have a problems finding an open source alternative where your old spreadsheets are 100% functional. It adds a new layer of complexity and a new target for developers to chase.
Getting the same VBA compatibility with applications that aren't developed by Microsoft can be tough. The language itself is descended from Microsoft's Visual Basic, and when used with tools like Excel, it's referred to as Visual Basic for Applications, or VBA. They're commonly used to trawl through large sets of data, or to input and output data to and from a specific source or worksheet. These are quick and informal chunks of programming logic that can be used to extend custom functionality to a spreadsheet when the default functions don't offer the facilities you're looking for. CALC: Most spreadsheet tasks can be accomplished with 's Calcīut Excel spreadsheets can be complicated, and in particular, they can be augmented with what are known as VB scripts and macros.
0 kommentar(er)
