Learn programming VBA with PowerPoint

[mbobro]

Hi,

I do have intermediate experience with programming VBA in Excel - I do
produce a set of reports from MS Excel data.
I have studied "Teach yourself series programming in Excel" and
"Practical standards for Visual Basic for Applications"
Last time I have used automation to export the data into MS Word, but
mainly used 'ready' solutions and tricks instead of learning Word VBA
in details.

Now I need to export data into PowerPoint. Most of the job is to I need
to make and update charts in PowerPoint that are made out of Excel
data.

Unfortunately, I don't know how to do that:
- Visual Basic help is more effective if you have precise question
- Books that are about VBA programming seem to be not about PowerPoint
- Books that are about PowerPoint seem to be not about programming
- Internet search sometimes solves the issue, but sometimes you may
surf for ages without finding abything

Maybe I should deepen my VB knowledge so'll be able to program with the
support of Object Browser or I should get something very PowerPoint
step-by-step oriented tutorial?

Is that anyone that may recommend me a book or a site that I may get
information I need?


Thanks a lot,

Michal Bobrowski

 

[Steve Rindsberg, PPTMVP]

Is that anyone that may recommend me a book or a site that I may get

information I need?

Hi Michael,

I'd suggest starting with the VBA programming section at www.pptfaq.com

Do a little browsing there, and particularly follow the links to other
MVP/Office sites (Shyam Pillai, Chirag Dalal, Tushar Mehta ... who've I
missed, folks?)

 

[B]

By far the best option for answering a specific PP VBA question is to post
it here, to the NG. I know that doesn't help sell books, but it is what is
currently best.

A lot of posters think they know VBA until they try to do something in
PowerPoint, then our guru's (and sometimes Steve) set them straight.

B

 

[Jan Il]

By far the best option for answering a specific PP VBA question is to post
it here, to the NG. I know that doesn't help sell books, but it is what is
currently best.

A lot of posters think they know VBA until they try to do something in
PowerPoint, then our guru's (and sometimes Steve) set them straight.

B

You sure have that right, B! <g> I also develop Access databases, and use
VBA a lot in that program. But, I sat in on all 3 of the PowerPoint
Automation sessions covering VBA at the recent PPT Live conference, in which
both Steve and Brian Riley were the Speakers, and believe me, it really *is*
a bit different. Not the Syntax, it's basic, but, mostly in how the code is
structured. Whew! Sure glad the two of them explained it so clearly.
Well...after they decided which of them was Right and Wrong, of course.
;-)))

Jan

 

[Steve Rindsberg, PPTMVP]

A lot of posters think they know VBA until they try to do something in

PowerPoint, then our guru's (and sometimes Steve) set them straight.

<g>

I'd put it a little differently - at least from my POV. We learn more about
VBA in those other (less important) apps while answering questions about
using in in The Centerpiece of Office, The Crown Jewel, Pride of Microsoft.

That'd be MS Photo Editor, of course. Though PPT's fun too.

B

 

[Steve Rindsberg, PPTMVP]

structured. Whew! Sure glad the two of them explained it so clearly.

Well...after they decided which of them was Right and Wrong, of course.

That'd be Wright and Rong.

Wright as in Steven Wright, which goes a long way to explaining ReillyLogic.
;-)

Jan

 

[B]

Wasn't aware MS PhotoShedder (wasn't it you that coined this phrase?) had
VBA support. Invaluable for those complex rotate and balance issues, I
suppose. So much to learn, so few people to pay me to. (g)

B

A lot of posters think they know VBA until they try to do something in
PowerPoint, then our guru's (and sometimes Steve) set them straight.

<g>

I'd put it a little differently - at least from my POV. We learn more about
VBA in those other (less important) apps while answering questions about
using in in The Centerpiece of Office, The Crown Jewel, Pride of Microsoft.

That'd be MS Photo Editor, of course. Though PPT's fun too.

 

[Jan Il]

That'd be Wright and Rong.

Wright as in Steven Wright, which goes a long way to explaining ReillyLogic.
;-)

Oh yeah...you're right...I'm wrong. After looking at all those codes my eyes
started playing games with me at the time.

Jan

 

[mbobro]

I'd like to thnak everyone for posting answers to my question. It's
really nice.

Steve: I browse your page & I've found some dealinks. How may I
indicate them to you?

Best regards,

M.

 

[Steve Rindsberg, PPTMVP]

Wasn't aware MS PhotoShedder (wasn't it you that coined this phrase?) had

VBA support.

MS PhotoShreddit ... yeah. <g>
And it doesn't. Have VBA support, that is. That's what makes it so easy to
program in VBA.
You don't. Done!

 

[Steve Rindsberg, PPTMVP]

I'd like to thnak everyone for posting answers to my question. It's

really nice.

Steve: I browse your page & I've found some dealinks. How may I
indicate them to you?

First, thanks for offering. Much obliged.

Post the info here if you'd like. That'd be fine.
Let me know the URL of the page and the link text if you would. Thanks!

 

[mbobro]

Steve,

Thanks again for help and I'm happy to contribute a bit with deadlinks
at your page:

I've started with the page:
http://www.rdpslides.com/pptfaq/FAQ00032.htm

Please check the links in this section:
OfficeVBA Magazine's site is well worth your attention.

And even more links, thanks to PPT newsgroup member LA:
VBATutor
VBA PowerTools
VBA Tutorial

That's all I have.
I'm still using your site, so, in case I'll keep you informed ))

Michal

 

[Steve Rindsberg, PPTMVP]

Thanks, Michal!

I've removed the dead links. And the one that led to a ... a ... a site
that I wouldn't want to lead anybody to.