getting excel data in powerpoint ?

[ErikVI]

Hi,
we wish powerpoint play with occupancy of rooms (Zaal in Dutch)(in appendix an example which was filled in manually)
the room occupancy is kept up in excel file and adapted each day(example also in appendix)

the intention is that the power point would be updated automatically.
- in the heading comes the name of the group which has booked.
- the hours they wish which use the room are comming below the headher.
- we strive for maximum two groups for each slide.

is this feasable with excel and powerpoint?

who give can me the solution?

 

[SkipVought]

Hi,

Some of us cannot access your file due to company security restrictions.

Please describe your requirements in detail, including the data tables strored in Excel, the mapping of data from Excel to PP and the structure of your PP slides.

What controls do you need?

What kind of user interface do you need for entry of data and control parameters?

How conversant are YOU with VBA, the Excel Object Model and the PowerPoint Object Model?

If you are not, do you have a professional programmer who is?

Please answer each if these issues with appropriate clarity, conciseness and completeness.

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

 

[ErikVI]

Hi,

I've sent both files tot the share server below.
you can find the links here:

http://www.mediafire.com/?m1zcyf644xni46v

http://www.mediafire.com/?ozy8z0ta80sc5u9

the excel file has two sheets
(one for room 1 and one for room 2)
each sheet has three colomns
reservation group name, begin and end hour
(a group can have reservations on different hours)

in the power point, the reservations of room 1 must come on the pages of room 1, those of room 2 on the pages of room 2
(they have other backgrounds)

we want to see max two groups on one page
(with each their own reservation hours)
something like this:
GROUP 1
08u00 - 10u00
10u30 - 12u00
GROUP 2
14u00 - 18u00
if there are more than two groups, we nee more pages
(I can make enough pages ot fill and delete the blanks later)

we are working in office 2003
the excel data comes from a query on the reservation database.

I know a litlle of programming, java, but not so much about VBA

greetings,

erik