By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,342 Members | 1,209 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,342 IT Pros & Developers. It's quick & easy.

Exporting Access query onto powerpoint tables (VBA)

P: n/a
Rob
Hey folks, my mind is turning into mush...

I created a report tracking program in access that works beyond my
greatest expectations. So of course, I am constantly adding features
to make life easier for my users (and harder for myself).

Every week my secretary exports different sets of data into Excel (via
cmd buttons on form) then copies and pastes the data into powerpoint
slides for our weekly staff meeting. I want to simplify this process
and load the data directly into Powerpoint Slides

(Using VBA from MS Access)

- OPEN an exististing Powerpoint Presentation that contains a TABLE
that I already formatted to hold the query data.

- Pull information from a Query to populate the Powerpoint table
-- Using RECORDSET or multidimensional ARRAY (I hate VBA Arrays),
whichever is easiest

I tried connecting to powerpoint about a dozen different ways, but
when I try to populate the cells of the powerpoint table, I get errors
or nothing happens.

Rather than show my (dozens of) mistakes, I'm asking for code examples
or good web sites to connect (from Access) into Powerpoint then add
data.

I've searched google, but most (actually all) of the code examples did
not work as advertised. I (believe) I referenced the appropraite
libraries, so that is not an issue.

Any help would be greatly appreciated.
Rob

Jul 4 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.