Prev: forcing regression equation to zero
Next: GUI compiling problem
From: Richard de Garis on 17 May 2010 16:21
Dear All,

This is a bit weird, but if I start up an Excel process, using the following:

Excel = actxserver('Excel.Application');
invoke(Excel.workbooks,'Open',[PATH FILE]);

and I do stuff like reading and writing data using the customized functions, downloaded from this site:

xlsread1, xlswrite1

and then save the workbook using:

invoke(Excel.ActiveWorkbook,'Save');

then when I terminate the process using:

Excel.Quit;

The process in the Windows Task Manager does *not* disappear like it should. If I do not invoke the Save, then the process is removed after Excel.Quit. I'm sure it didn't use to behave this way. Any ideas?
From: Richard de Garis on 17 May 2010 16:36
Ooops, I meant to write Excel.delete, not Excel.Quit. The problem still persists, though.
From: ImageAnalyst on 17 May 2010 16:47
Here's my code:

% Now save the workbook to disk.
invoke(Excel.ActiveWorkbook,'Save');

% Shut down Excel.
Excel.Quit
Excel.delete
clear Excel;

This is the way I've always done it and it's always worked. You know
how to do it now, so don't worry about how you think it used to work.
If it works, hey, great! You're done.
From: Richard de Garis on 17 May 2010 16:57
ImageAnalyst <imageanalyst(a)mailinator.com> wrote in message <bfe44359-ed4d-4670-a16a-3dc19e4d5ea7(a)o15g2000vbb.googlegroups.com>...
> Here's my code:
>
> % Now save the workbook to disk.
> invoke(Excel.ActiveWorkbook,'Save');
>
> % Shut down Excel.
> Excel.Quit
> Excel.delete
> clear Excel;
>
> This is the way I've always done it and it's always worked. You know
> how to do it now, so don't worry about how you think it used to work.
> If it works, hey, great! You're done.

That's what's so weird; how you've always done it is how I've always done it... and now it's not working... unless I don't save, then it works.
From: ImageAnalyst on 17 May 2010 18:00
Oh, I didn't read your first message accurately enough. It looks like
you still have the problem - if you save, it won't shut down Excel.
Well for me it does, so can you make up a little 10 line program that
demonstrates the problem? Give it to tech support (post it here too
so I can try it) and see if it works or doesn't work for them.
 |  Next  |  Last
Pages: 1 2
Prev: forcing regression equation to zero
Next: GUI compiling problem