How can I include a VB script in a Matlab code?

I have a VB script written for several Excel functions. The purpose is to calculate the properties of flue gas at different conditions based on its composition. The VB script has the description of the each function and its variables and it calls the results from a dll file, which, I suppose performs the calculation and returns the value to the VB script. Now if I want these to be written on a MATLAB code how can I call a function which performs the same task as the VB script by calling the dll file?

Answer 1

[Aylin]

Hi Sriram,

MATLAB has several external interfaces which could be used to call external scripts and DLLs:

1. If you want to call functions from a generic DLL (C/C++ shared library), the loadlibrary function can be used:

loadlibrary('MyLibrary.dll', 'MyLibrary.h')

2. MATLAB can be called as a COM server from a Visual Basic script:

https://www.mathworks.com/help/matlab/matlab_external/call-a-matlab-function-from-visual-basic-net-client.html

3. MATLAB can also call other COM objects , or use the COM API to control an Excel instance from within MATLAB :