What can we create with Visio & Excel VBA with this compelling new functionality in Excel?
https://www.theverge.com/2020/10/29/21539844/microsoft-excel-custom-data-types-power-bi-wolfram-alpha-power-query-data
I think no way! This opportunity works only for office365...
Doesn't it work in the Excel desktop application? That means Office 365 subscribers can get it and it will be in the next Desktop release (Microsoft fortunately will keep doing perpetual licenses!)
Check out this info and video for more:
https://techcommunity.microsoft.com/t5/excel-blog/announcing-power-query-data-types/ba-p/1782903
Quote from: Visisthebest on October 31, 2020, 08:58:21 AM
Doesn't it work in the Excel desktop application? That means Office 365 subscribers can get it and it will be in the next Desktop release (Microsoft fortunately will keep doing perpetual licenses!)
fyi
Quote from: MS in article Connect to your own data with more new data types in Excel (https://www.microsoft.com/en-us/microsoft-365/blog/2020/10/29/connect-to-your-own-data-with-more-new-data-types-in-excel/)If you're a Microsoft 365 Personal or Family subscriber in the Office Insiders program, you may have noticed that the Stocks and Geography data types have a few new neighbors in the ribbon. We are currently previewing the first several of over 100 new data types that will pull rich information from Wolfram Alpha's online service into Excel.
To complement these data types, we are also building a new set of smart templates. The new smart templates will enable people to quickly get started with data types, and do things like track their nutritional information, research potential colleges, monitor stocks, learn chemistry, and much more.
We'll be sharing more information about Wolfram Alpha data types as we get closer to general availability. In the interim, we hope you'll join the Office Insiders program and give us your feedback!