Jim,
Thanks for your help. I was able to use this in conjunction with Tom's code,
and once I found all the .acs files, I was able to code a meathod of
selecting whichever assistant I wanted.
regards
Pete
"Jim Cone" wrote:
Hello Peter,
In vba help look for the "assistant object".
One line in there says:
"The default Assistant is Rocky.
To select a different Assistant programmatically,
use the FileName property."
I provide no example as I have never used it.
Regards,
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
"Peter Rooney"
wrote in message
Good afternoon, all.
I realise that the Assistant is part of Office and not Excel, so (I think) I
understand why, when I record myself changing the assistant, nothing is
recorded.
The question is, of course, how DO I code a change of Assistant?
Thanks in advance
Pete