|Written by Mike James|
|Thursday, 24 May 2018|
In one of the most disconnected decisions in the whole history of Microsoft, back in 1998 the languages team decided to kill Visual Basic 6 to make sure that its new .NET initiative had a better chance of success.
The reason it was, and still is, disconnected, is that Office used VBA as its macro or scripting language and VBA is essentially VB6. Despite several attempts to get .NET into Office most users are stuck with VBA as a scripting language. Now that .NET is also on its way out it seems doubtful that it will ever become the scripting environment for Excel.
You can set up parameters to accept a cell range as well as single cells.
Functions can be synchronous or asynchronous. Async functions return a promise which allows Excel to stay responsive while waiting for a result. Typically async functions can fetch data over the web. Asynchronous functions can also be streaming in that they can return multiple data items to cells without waiting for a recalculation.
There is a GitHub repro for the trial but you still need to use a very recent build of Office and join the Office insider program to try it out.
or email your comment to: firstname.lastname@example.org
|Last Updated ( Thursday, 24 May 2018 )|