run VBA MACRO in MATLAB

HI, I want to run the VBA code(some small macro) from matlab.I can do that by invoking the Excel(using actxserver) and run the macro in the excel but my point is that i want to run the VBA macro directly from matlab without opening any third application

I hope i stated clearly my problem :)

Answer 1

[Walter Roberson]

VBA is built in to Excel so a third application is not being invoked.

VBA is only available as built in to applications; it is not available by itself. This is by design, as VBA is "Visual Basic for Applications".

[Zunnoorain Farooqui]

so as far as i understand, I must invoke the Excel to run the VBA script and there is no other way by using which i may reduce some time and CPU load?

is it right?

[Friedrich]

As long its a Macro in EXCEL you have to start EXCEL to run it. What does this Macro do? Maybe you can convert it to MATLAB code? Or maybe some VB script? You can run a VBS script without opening a 3rd application since this is a Windows built in feature.

[Walter Roberson]

If it is VBA then unless you can rewrite it, you must start _some_ application in order to execute it, as VBA is, by definition, something that is built in to applications.