Access Data to Populate Excel based Powerpoint slide

[newestAF]

This is something I haven't tried before. Have a dbs that I need to extract data and input into a specific slide on a ppt presentation. Slide has custom background we're required to use but the data has an embedded excel spreadsheet. What's been done in the past was to update dbs, update excel spreadsheet, cut and paste out of excel into the ppt slide. I would like to click a button and have access VBA input the data directly into the ppt.

 

[SkipVought]

Hi,

So you want your Access data to go into a WHAT?

A PowerPoint Textbox? WHAT?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[newestAF]

I have a powerpoint presentation that has an embedded excel spreadsheet. I need the data from access to open one specific slide and update the excel spreadsheet on that slide. I tried to recreate the custom background in an access report but the field sizes for the data don't adjust according to the amount of data.

 

[SkipVought]

What code do you have so far?

Do you also have another problem with an Access report?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[newestAF]

I haven't had much time working with it. I know I could open the ppt using vba and was thinking of using on "on dirty" instance for a recordset to open and update the slide. Not sure if that's the best approach but not sure how to with an embedded excel. That's where I start to get lost.

 

[SkipVought]

Checl out the GetObject method in VBA. There are some good code examples.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]