I have a tough requirement i have not managed to solve, hope community can help me on this.
I wish to implement a book of products under powerpoint. A marketing team will work on the visual part of the book. Inside the slides, there will be text descritpions and references regarding the products present on the slides Ex :
Product A : The best product in the world ref: 1234#EU#ZZ#6789
What i need is to find a way to fetch from each powerpoint slides, data present inside an excel file depending on the references present in the slide. There can be 1 to 20 references on a slide. There will be 5 information fetched in Excel cells : Bx, Cx, Dx, Ex, Fx where :
x will be the lines that will have in cell Ax, the 1234 information available in reference issued of powerpoint slide.
Bx will be a geozone information (EU,US,AZ,AF, etc..) that will discriminate Ax lines depending on this geozone information
Cx will be a technical reference ZZ that will discriminate Ax lines depending on this technical reference
There will be only one combination of Ax / Bx / Cx (1->1), but there can be numerous combinations of Ax / Bx, or Ax / Cx. (1->n)
Dx will be an optional information in case of further needs (but not implemented yet) : 6789 information can be absent (and the Hyphen before information also)
Last but not least :
Ex and Fx will be the informations that will have to be returned to powerpoint and inserted inside the slide (data that can change annualy, such as pricing, discout levels, etc..)
I have tried to find working vba examples but with no success and i am not good enough in VBA to code this from scratch (i have tried without success)
Does any one know a working approach of my needs i could try to adapt ?
Thanks by advance