From: Adam Chapman on
Im making a GUI that ushas an excel workbook in it.

Im trying to go through the 3 existing sheets in that workbook and
change their names.

I have managed to change the name of the first sheet with:

ActSheet = get(handles.activex1,'ActiveSheet')
ActSheet.Name='Motoring';

But haven't managed to move on to the second and third sheets. Any
help is greatly appreciated
From: us on
Adam Chapman <adamchapman1985(a)hotmail.co.uk> wrote in message <5d44916e-4987-4eda-915d-f17d93470975(a)k39g2000yqd.googlegroups.com>...
> Im making a GUI that ushas an excel workbook in it.
>
> Im trying to go through the 3 existing sheets in that workbook and
> change their names.
>
> I have managed to change the name of the first sheet with:
>
> ActSheet = get(handles.activex1,'ActiveSheet')
> ActSheet.Name='Motoring';
>
> But haven't managed to move on to the second and third sheets. Any
> help is greatly appreciated

this was shown to you a few weeks ago...
- it includes moving from one sheet to another...
do you even bother to look at replies to your OPs...

us
From: us on
Adam Chapman <adamchapman1985(a)hotmail.co.uk> wrote in message <5d44916e-4987-4eda-915d-f17d93470975(a)k39g2000yqd.googlegroups.com>...
> Im making a GUI that ushas an excel workbook in it.
>
> Im trying to go through the 3 existing sheets in that workbook and
> change their names.
>
> I have managed to change the name of the first sheet with:
>
> ActSheet = get(handles.activex1,'ActiveSheet')
> ActSheet.Name='Motoring';
>
> But haven't managed to move on to the second and third sheets. Any
> help is greatly appreciated

this was shown to you a few weeks ago...
- it includes moving from one sheet to another...
do you even bother to look at replies to your OPs...

http://www.mathworks.com/matlabcentral/newsreader/view_thread/285795#758671

us