VBA Project Need Help! URGENT

  • Thread starter Thread starter Jake Cole
  • Start date Start date
J

Jake Cole

I am familiar that there are non-code ways to do this, but they do not
meet my main requirement, which is to take a process that normally
takes 3hrs to do, to a process that takes minutes, with as minimal
human intervention and post proceedure run formatting as possible.

The situation is this we have a word document with a fully typed out
sermon and songs in a word document that we then have to take and put
into a blank PowerPoint PPT. As it stands now we are manually doing
all the text transfer and text formatting manually and we have to do
it multiple times weekly for different sermons.

Basically this vba proceedure needs to transfer all the text from the
word document on to a completely blank PPT slide. The slide show needs
to have around 130 blank slides. All the text needs to be White, Arial
Font, witj the exception of sermon text which can be Arial 34, white
and the exception of Song Title Slide which needs to be Papyrus Font,
60 font.

For Songs, We usually fit about two to three lines of a verse on a
slide, we put a logical space between lines that dont seem to fit
together logically.

Sermon text can be smaller font, but still arial, with more text per
slide-- the key with the text is easy readablity-- from a large video
screen in a rativelatively good size room. The slide text must end in
a logical place and pick up where left off in the next slide, meaning
no half cut off words.

All text needs to be bolded and shadowed. at the end of each song
there must be a transition or blank slide, with a dissolve or fade
transition attached to that slide. At the end of the procedure all
slides with out after the last slide with text or content needs to be
deleted.

All slides are on the same text outline level with no bullet points or
slide titles, titles have there own slide.

This is a church congregation worship service.

I am attaching a word document which I get to begin with and a
finished product for example. Caution: some of the finished product as
far as font rules is not formatted correctly, so please follow the
rules I laid out in this discription, I am open to suggestions and
definately questions Thank you!

I am pretty familiar with VBA, but need some expert help.

Can Anyone point me in the right direction on this???

Thanks,
Jake
 
Jake,

This sounds like an interesting project, and you have explained what you
intend to do very well (except that I didn't see any attachments, and
attachments in newsgroups are generally frowned upon). I think you might
need to be more specific in your question. What specific help do you need?
If you were hiring me to do this project (not that I am available for hire),
I think I have enough information to go on. But short of designing and
developing a system for you, I am not clear about what you want.

Maybe some specific questions would be helpful. Are you looking for help
with the VBA coding that will connect PowerPoint and VBA? Are you looking
for help getting the slides broken up properly? Are you looking for help
getting the text formatted properly? Are you looking for suggestions of
resources that will help you? Let us know more specifically what you want
help with, and I'm sure someone here can answer your questions.

--David

David M. Marcovitz
Author of _Powerful PowerPoint for Educators_
http://www.loyola.edu/education/PowerfulPowerPoint/
 
Back
Top