Prev: MS VC++ Runtime error when start MATLAB!!
Next: Minimum gradient not reached ! please help
From: Anonymous on 10 Apr 2010 12:14
Hi,

I want to open a macro in Excel which is build in another excel-file. So the macro has a name like this:
Excelmacros.xls!vw_check

I tried to run this macro by matlab with:
Excel.ExecuteExcel4Macro('!Excelmacros.xls!vw_check()');

But the problem is the ! in the middle of the macro name.

Anyone an idea how to fix this?? I've also given the macro a shortcut (CTRL+M), so maybe it's a solution not to open the macro, but just to run the shortcut.

Tnx a lot!
From: Anonymous on 10 Apr 2010 12:24
"@ddie ertser" <ivogrunn(a)hotmail.com> wrote in message <hpq84d$p6n$1(a)fred.mathworks.com>...
> Hi,
>
> I want to open a macro in Excel which is build in another excel-file. So the macro has a name like this:
> Excelmacros.xls!vw_check
>
> I tried to run this macro by matlab with:
> Excel.ExecuteExcel4Macro('!Excelmacros.xls!vw_check()');
>
> But the problem is the ! in the middle of the macro name.
>
> Anyone an idea how to fix this?? I've also given the macro a shortcut (CTRL+M), so maybe it's a solution not to open the macro, but just to run the shortcut.
>
> Tnx a lot!
Btw:
macro-name = vw_check
excel-file where it is build = Excelmacros
From: Ashish Uthama on 12 Apr 2010 13:59
On Sat, 10 Apr 2010 13:14:06 -0300, @ddie ertser <ivogrunn(a)hotmail.com>
wrote:

> Hi,
>
> I want to open a macro in Excel which is build in another excel-file. So
> the macro has a name like this:
> Excelmacros.xls!vw_check
>
> I tried to run this macro by matlab with:
> Excel.ExecuteExcel4Macro('!Excelmacros.xls!vw_check()');
>
> But the problem is the ! in the middle of the macro name.
>
> Anyone an idea how to fix this?? I've also given the macro a shortcut
> (CTRL+M), so maybe it's a solution not to open the macro, but just to
> run the shortcut.
>
> Tnx a lot!

A guess: open the Excelmacros.xls in addition to whatever sheet/file you
are working on, then execute the macro using 'vw_chec()'
 | 
Pages: 1
Prev: MS VC++ Runtime error when start MATLAB!!
Next: Minimum gradient not reached ! please help