View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Changing the Office Assistant

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