View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Peter Rooney Peter Rooney is offline
external usenet poster
 
Posts: 325
Default Changing the Office Assistant

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