Can I create notes using VBA from other Office sources?

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

Guest

I am still trying to automate our office slideshow. However, we use the notes area to display the latest and greatest on a particular job. Can I create these notes using VBA?
 
Go to Google, click groups and enter
"How to import Speaker Notes from a file to an existing presentaiton"
in the search frame.

There is some code. You will be able to modify it to meet your need.

B

===============
Please spend a few minutes checking vestprog2@
out www.pptfaq.com This link will yahoo.
answer most of our questions, before com
you think to ask them.

Change org to com to defuse anti-spam,
ant-virus, anti-nuisance misdirection.
..
..

Allen Pinkley said:
I am still trying to automate our office slideshow. However, we use the
Click to expand...
notes area to display the latest and greatest on a particular job. Can I
create these notes using VBA?
 
Allen,
Yes, you can. You might find the following site useful - http://www.mvps.org/skp it has several examples for PowerPoint automation.

Regards
Shyam Pillai


----- Allen Pinkley wrote: -----

I am still trying to automate our office slideshow. However, we use the notes area to display the latest and greatest on a particular job. Can I create these notes using VBA?
 
I am still trying to automate our office slideshow. However, we use the notes area to
Click to expand...
display the latest and greatest on a particular job. Can I create these notes using VBA?
Use VBA to add text to the notes page?
Sure. Simplest form:

' Watch out for linewrap - the next bit should all be on one line
ActivePresentation.Slides(1).NotesPage.Shapes("Rectangle 3").TextFrame.TextRange.Text = "Here
ya go. Notes text!"

That sets the notes text on Slide 1 of the current active presentation.
By default, the notes text shape will be named Rectangle 3 but if somebody's deleted the
notes text placeholder then re-added it, the shape will have a different name and this code
won't work.

It gets a bit trickier then. <G>

First, let's see if this works for you.
 
Back
Top