Need VB for Office Assistant

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a help system for my Excel files using the Office Assistant
and now I would like to do the same for PowerPoint. Does anyone know how
this can be done? I can show you the code I am using for Excel if that would
help. In Excel the help text is stored in a hidden sheet. I'm not sure
where it would go for PowerPoint. Another ppt maybe. I just know I need to
create a help system for my users and so far I like using the Assistant.

All suggestions welcome,

DJ
 
I have created a help system for my Excel files using the Office Assistant
and now I would like to do the same for PowerPoint. Does anyone know how
this can be done? I can show you the code I am using for Excel if that would
help. In Excel the help text is stored in a hidden sheet. I'm not sure
where it would go for PowerPoint. Another ppt maybe. I just know I need to
create a help system for my users and so far I like using the Assistant.

I haven't messed with the Assistant past working out how to make him say rude
things about the world's richest man. I'm easily amused and equally easily
bored, I guess.

But the same code should work to make him do his tricks in any Office apps; the
problem is where to store the text for the PPT version, right?

What about storing the text in a text file or series of files?
 
Hi Steve. Thanks for taking the time to reply to my post.

Where did you store your text when you put words in the Assistant's mouth?
Using a text file sounds okay, but they don't print very nicely and I need
the words to look good on paper too. How about a Word document? Could I
store it in a .doc? In my doc I would contain a table with 3 columns. The
first column is for the step number. The second column is the heading like
"Printing". And the third column is the text, the actual step-by-step
directions. I'll give the .doc the same name as the ppt. Do you think that
will work?

If so, can you give me some simple code to help me get started?

I'd really appreciate it!
DJ :-)
 
Hi Steve. Thanks for taking the time to reply to my post.

Where did you store your text when you put words in the Assistant's mouth?

I was just playing around, so it was probably hardcoded in the VBA.
Using a text file sounds okay, but they don't print very nicely and I need
the words to look good on paper too. How about a Word document? Could I
store it in a .doc? In my doc I would contain a table with 3 columns. The
first column is for the step number. The second column is the heading like
"Printing". And the third column is the text, the actual step-by-step
directions. I'll give the .doc the same name as the ppt. Do you think that
will work?

If so, can you give me some simple code to help me get started?

I don't do much of anything with Word, but I'd certainly imagine it's possible.
You might want to ask in Public.Word.Vba.Beginners how to pick up the text from
a series of cells in a word table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top