Mycel

The Macro VBA will integrate programming codes into the Excel file. If you have 30 xls(x) files, that code will repeat 30 times, which makes it difficult to control and upgrade.

The Mycel add-in will integrate programming codes into Microsoft Excel software, not into the file. This means if you have 30 excel files, the files will only contain the final result, not any control code. Thus, when the functions are upgraded, all files can be updated instantly. 

A macro function get text parameters and return a text result. A Mycel function get text parameter and return a text result,  an image, or a formatted text.

Macro VBA can contain malicious code, so Microsoft Excel always considers macro excel files to be unsafe, displays warnings and requires file viewers to enable Macro. From Excel 2017 onwards, it is specified that xls(x) files containing macro must have the file extension xlsxm for easy identification by viewers.

Mycel does not embed the control code in the excel file. The file xls(x) contains only the function citation and the result of the function, so it is very safe. .

Mycel's calculation functions can connect to cloud services to present to you unprecedented data experiences.

Let’s imagine, you type a function expression into the cell like any other formula, then Enter. This enables dozens of service servers to perform searching, exploring, querying, and artificial intelligence algorithms. After a few seconds, the results appear in that cell, simple and transparent, embracing the state-of-the-art technology. 

Mycel add-in can operate wherever Microsoft Office works. For example, Office on  mobile phones, on tablets, and Office Online on web browsers.

Macro VBA can only run on the Desktop version (offline). Macro VBA is not suitable for modern trends such as cloud computing and cross-platform integration. 

Mycel add-in is available on the Microsoft Store, tested and approved by Microsoft. You only need 30 seconds to install, and you can do that anywhere.

Mycel add-in comes with the Microsoft Office login account, not the computer. In other words, once you install Mycel on any computer, you will be able to use Mycel on all devices such as tablets, mobile phones and web browsers.

Macro VBA requires the editor to first open the macro editor, enter the code, and store the code inside an xls(x) file. To continue using the macro function in the new xls(x) file, the editor can repeat the above steps, or for convenience, usually copy an xls(x) file that already has the macro code and then update the data.
Users of macro VBA also usually store those codes in a separate text file, so that they could be copied to the xls(x) file when needed.