export data to PowerPoint through vba

[MyJuliette]

I have data from db. i need to export data into PowerPoint through vba. I need to do it code. I know how to export data into Excel, not just exporting data, but working with excel object open it, export into specific cells and close it. I need to do the same thing with PowerPoint and i am curious if i can do same thing with PPoint.

 

[SkipVought]

Hi,

You cannot do the same thing in PP that you can in Excel, sine you are working with a different object model.

Please explain what you want to do...

Put text in a PP object such as a shape???

Insert an OLE object such as a chart or sheet???

?????????

Skip,

_{[red]Be Advised![/red] Dyslexic poets...
write inverse!}

 

[MyJuliette]

ok, i am new in PP. I just find out clear specs what to do. I have an excel file with all nessesary inforamation by Client Name etc. I have PP presentation, but i need to update individual client slide based on Excel's client name. Particular data must be modified in a slide and then resaved. Also, i need to replace image from one that is exists in a slide to another. Also, there is a chart in a pp slide needs to be modified based on the values in excel. i don't know how to do all of this in pp.
thanks for your help.

 

[SkipVought]

One client/slide set or multiple clients/slide sets?

Update what object(s) on the slide?

What does "...replace image from one that is exists in a slide to another..." mean?????

Regarding the chart, why not format the chart in Excel and embed it in PP?

Skip,

_{[red]Be Advised![/red] Dyslexic poets...
write inverse!}

 

[MyJuliette]

Thanks for your response.
ok, in excel there is a client name, company name, sales amount, Month of the sale, etc columns, the list of all clients and thier info. we have power point presentation already with some clients from the list, because it was manually entered/modified each month. user wants to automate update on power point file based on the values in excel. Total sale: should be modified, Chart based on sale of the month, and image is a logo of the company. each time clients might work with different companies.
ok, look like each client has specific slide.
there is no charts in Excel, only values. i need to modify in pp based on values in excel.
moreover i am working from Ms Access, can i do all modifications from Access?
if not clear again, then u may ask more questions.

 

[SkipVought]

Seems like a convoluted way of doing things.

If I have a Table in Excel as you described,, I'd do the entire thing in Excel using...

a summary sheet for chart source data
a drop down box to select a client
either cells on the sheet or textbox in the chart to display ALL client-specific information including the client-specific logo.

It would be pretty simple.

Skip,

_{[red]Be Advised![/red] A man who jumps from a bridge in Paris, is…
INSANE!}

 

[MyJuliette]

this is what i have and user doesn't want to change anything, he wants pp presentation.
ok, my question, can u help with it?

 

[SkipVought]

So do it in one application like Excel -- it could even be Access if you are more comfortable there -- Copy the Chart/Data and PasteSpecial as some kind of graphic in PP.

Skip,

_{[red]Be Advised![/red] A man who jumps from a bridge in Paris, is…
INSANE!}

 

[StuckInTheMiddle]

It sounds like MyJuliette simply wants a PowerPoint file that links to data in Excel that can be updated and have PowerPoint automatically refresh with the latest data? Am I understanding that correctly?

If so this can be done in VBA where you copy your XL charts for isntance and put them into PowerPoint as Shapes. Sorry I dont have a coded example, but do a google search I know they are out there.

 

[MyJuliette]

hi StuckInTheMiddle,
Yes, you are right, this is might be a solution.
I will search for it, but if you will find some source code, please sent it to me.
thanks.

 

[Bong]

Alternatively, you can "paste as link" in PP from Excel, without any macro code. Whenever the Excel data changes, the PP slide updates.

_________________
Bob Rashkin

 

[MyJuliette]

can u send me any example link or zip file? i am new in pp. thanks

 

[Bong]

I don't know how to send you an example but the process is pretty simple:

In Powerpoint, go to the slide where you want the link to Excel to be. Use the layout with only a title block.

Select "Insert" on the menubar, then: "Object..."

Select the "Create from file" radio button

Browse for the spreadsheet file you want.

Choose the "Link" check box.

_________________
Bob Rashkin

 

[MyJuliette]

i'll try. thanks anyway